Subject Source for index design
Author Rick DeBay
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
561-650-8195 x-215