I will create many indexes ,what will be?

Hi,
In my application,there will be many indexes to be created,and some indexes should be created dynamically,is there any question?
And how should I can calculate the space of indexes?

thanks

--Ford

This message was edited 1 time. Last update was at 26/10/2008 16:18:35

agile.guo wrote:
In my application,there will be many indexes to be created,and some indexes should be created dynamically,is there any question?

No problem at all. Indexes can be created dynamic. Just like with any relational database, the indexation process can take long if your dataset is large. I would not worry for anything < 500k.

If you are indexing a huge dataset, it is better to do it offline, with your system off, to avoid write locks. Same problem with any relational database.

And how should I can calculate the space of indexes?

Not easily. Java will not easily tell you the ammount of memory an object is taking. There are hacks to do this. Google it and if you get a good solution please share with me.