Re: [PERFORM] How to determine which indexes are not using or using seldom in database

2007-04-02 Thread Andreas Kostyrka
* Denis Lishtovny <[EMAIL PROTECTED]> [070402 09:20]: >Hello All. > >I have a lot of tables and indexes in database. I must to determine which >indexes are not using or using seldon in databese . I enabled all posible >statistics in config but a can`t uderstand how to do this. >

Re: [PERFORM] How to determine which indexes are not using or using seldom in database

2007-04-02 Thread Thomas Pundt
Hi, On Monday 02 April 2007 10:12, Denis Lishtovny wrote: | I have a lot of tables and indexes in database. I must to determine which | indexes are not using or using seldon in databese . I enabled all posible | statistics in config but a can`t uderstand how to do this. | Thanks. Try "select * fr

[PERFORM] How to determine which indexes are not using or using seldom in database

2007-04-02 Thread Denis Lishtovny
Hello All. I have a lot of tables and indexes in database. I must to determine which indexes are not using or using seldon in databese . I enabled all posible statistics in config but a can`t uderstand how to do this. Thanks. p.s for example i need this to reduce database size for increase backup