ca.portal.admin

DB2 gets a db-key

Discussion created by ca.portal.admin on Aug 24, 2010
Latest reply on Aug 24, 2010 by ca.portal.admin
IBM has finally given in - DB2 10 will include hash key support: =
""Hashing
is a technique that turns a key into a physical location of a row, =
resulting
in one-page access for a matching row on an equal predicate."" Sound
familiar?

The year is 2010. What year did the IDMS db-key become available?

Kay Rozeboom
State of Iowa
Information Technology Enterprise
Department of Administrative Services
Telephone: 515.281.6139 Fax: 515.281.6137
Email: Kay.Rozeboom@Iowa.Gov
"
IDMS 3rd-party providers forum
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP
IDMSVENDOR-L@LISTSERV.IUASSN.COM
IDMSVENDOR-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: DB2 gets a db-key
"Amazing!

Not only is it in IDMS but Cullinet had that capability in their first SQL
offering, Enterprise DB for VAX and UNIX back in 1988! The decision makers
in the relational marketplace yawned. Some might say they were SLOW by
taking 22 years to figure out that B-Trees are not the only way to index
data but not me. That would be rude. Like you, I too am pleased to see
them learn something from IDMS. Dare we dream? Could VIA SETs be next?

BTW I think ORACLE does have a hash key mechanism of some sort. From the
10g performance and tuning page: ""Support for hash partitioned global
indexes has been added in Oracle 10g"". 10g? Wasn't that recent? Well at
least they're ahead of DB2.

IDMS is still the best,

Tom Hebert
ObjEx, Inc.
28248 N Tatum Blvd
Ste B1-268
Cave Creek, AZ  85331
Tel: 01 (908) 813-2866
Fax: 01 (208) 567-1879
email: Tom.Hebert@obj-ex.com
web: http://www.obj-ex.com
""IDMS for the Java Generation""

Outcomes