Re: [firebird-support] Find rarely used or unused indices

2016-04-08 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
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

Re: [firebird-support] Find rarely used or unused indices

2016-04-08 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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

[firebird-support] Find rarely used or unused indices

2016-04-08 Thread Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]
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