John Wright wrote:
>I have lost you here. If not on disk or memory, where are you supposed >to store indexes? Do you mean that actually it might not be the case to >have some indexes?
Either user chosen indices,
OK, this is exactly what is done now: in order to have an index the administrator has to explicitely ask for it.
or system adaptive indices, where frequently run queries "create" more indices on the data being queried. It would be similar to the idea that results from frequent queries are cached; instead of caching, new index creation could be triggered, thus giving sort of an on-demand system.
And this is exactly what I had in mind. I was wondering if this procedure should be fully automated or if it should just give to the administrator some hints about indexes to create. Probably something in between would be the best bet.
Ciao,
-- Gianugo Rabellino
