Home Forums SQL Server 7,2000 Performance Tuning Confusing query plan RE: Confusing query plan
HenryTr
SSC Eights!
Points: 845
More actions
June 23, 2003 at 1:57 pm
#462700
If the table is going to take up more than a couple of pages, use a clustered index. Otherwise you can get a 'heap' where the query hops all over the place and end up with as many IO operations as there are rows.