Subject | Source for index design |
---|---|
Author | Rick DeBay |
Post date | 2004-07-14T17:14:50Z |
Is there a good web source for information on designing indexes?
I'd like to know when to use a multiple element index, single element
index, and whether ascend and descend is standard SQL and when it makes
a difference.
I know optimizing queries can be a black-art and can be vendor
dependant, but I'd like to brush up on what can be done according to
SQL99 specs.
Rick DeBay
Senior Software Developer
RxStrategies.net
561-650-8195 x-215
I'd like to know when to use a multiple element index, single element
index, and whether ascend and descend is standard SQL and when it makes
a difference.
I know optimizing queries can be a black-art and can be vendor
dependant, but I'd like to brush up on what can be done according to
SQL99 specs.
Rick DeBay
Senior Software Developer
RxStrategies.net
561-650-8195 x-215