Hi,
> What is the best way to go about to find out about this?
>
> I have several projects that are using the FB database and I would like
> to cleanup and remove all the indices that are just taking up space and
> thus indirectly reduces performance?
It is not that easy to clearly define the use
Hi,
Check your database with Database Analyst from HQbird (trial will be
enough) and look at the list of Useless indices (indices with only 1 key
for all values) and Bad indices (with a few keys for many values).
Then, you need to run tracing of your database in action, for example,
with HQB
Hi
What is the best way to go about to find out about this?
I have several projects that are using the FB database and I would like to
cleanup and remove all the indices that are just taking up space and thus
indirectly reduces performance?
Best regards
jardar