|
|
Posted by Doug on 10/01/88 11:41
3 seconds is a long time.
how do we make it faster??????
i am not a huge fan of clustered indexes. However for a reference
table where you will ALWAYS be looking up data utilizing a specific
column, and rarely inserting into the middle, I'd sure consider it.
For grins, try creating a clustered, composite index on starting_bigint
+ ending_bigint.
For grins after that, consider a clustered index on trans.bigint.
warning: clustered indexes on trans tables are usually not a great idea
IMO, unless the clustered index is based on a timestamp or an identity
column.
-doug
Navigation:
[Reply to this message]
|