Subject Indexing Questions
Author Anthony Tanas
I want to index an APPOINTMENT table to speed up my selects. The two fields
I frequently select on are APPOINTMENTDATE and APPOINTMENTTIME.

I believe I should index APPOINTMENTDATE *descending*, since I generally
access more future dates then past dates. Am I correct?

Should I index both fields combined in one index or index them individually
in separate indexes?