If indexes are so important, why not index every column in every table? (Include a brief discussion of the role played by data sparsity.)

 What is the difference between a rule-based optimizer and a cost-based optimizer?

 What are optimizer hints, and how are they used?

  What are some general guidelines for creating and using indexes?