Post reply

hashing vs full table scan

  • November 10, 2003 at 8:42 pm

    #107407

    Does SQL Server do any hashing when you execute a select with a where clause that is for a column that is not indexed? I always thought it did a full table scan in this case. I was told today that indexes are not always created for easily hashed data. I haven't been able to find any info on hashing in SQL Sever other than hash joins.

  • November 13, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • November 13, 2003 at 1:50 pm

    #481964

    No. As setting up hashing requires table scans, that makes no sense. The logic of not indexing where the values may be "easily hashed" is relevant only to joining on the columns, and doesn't make a lot of sense to me unless the tables have few rows, you're always doing equijoins, and memory is cheap.

    --Jonathan



    --Jonathan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply