Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2002-09-20 : 16:35:36
|
| Hi Folks,I have a clustered index on a table. The index is on a column of type varchar. When I run a query and in the where clause i use the column which has a clustered index, In the execution plan, the first step is a Index Scan and then a bookmark look up, why is it not using a index seek instead.The query is SELECT * FROM dbo.software WHERE individuals_id='10001'there is a clustered index on column individual_id.Any ideas.ByeRamdas NarayananSQL Server DBA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-20 : 16:53:33
|
| Bookmark lookups are used with a clustered index; nonclustered indexes will favor index seeks/scans. An Index Scan is more generalized than an Index Seek, and is more appropriate for use in this particular query.Each of the Bookmark, Scan, and Seek operators has entries in Books Online that explains their behavior in more detail. |
 |
|
|
|
|
|
Clustered Index