October 6, 2004 at 11:12 pm
What are hash indices? can any one tell me useage of this
My Blog:
October 7, 2004 at 12:48 pm
Basically, a hash index uses a computed value instead of the real value. There is a topic "CHECKSUM" in SQL Books Online that shows an example. In this case, the CHECKSUM function is used on the string to come up with a number that is stored in a new column. An index is created on the new column which will be faster than an index on the character column.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
October 14, 2004 at 4:16 am
The Hash index is not present in SQL 2000. It is only in Oracle, where it is effective in querying large tables mainly for analytic or OLAP purposes.
RKM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply