RB Smissaert wrote:
.... I think an application that
would produce all the needed indexes based on the table and all the possible
queries would be helpful. Anybody done such an app?
_All_ possible queries? Not practical for any significant number of
columns. N factorial gets big fast.
The indexes would be much larger than the data base itself.
I'm afraid you are going to have to settle for doing an intelligent
design of the data base.
Gerry
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------