Обсуждение: How to check if index is valid

Поиск
Список
Период
Сортировка

How to check if index is valid

От
"Vladimir Rusinov"
Дата:
Hello!

How can I check if all indexes in my database is valid, how to show the invalid ones (and rebuild them)?
Any quick solutions?

Thanks.

--
Vladimir Rusinov
Voronezh, Russia

Re: How to check if index is valid

От
"Richard Broersma"
Дата:
On Mon, Mar 3, 2008 at 3:55 AM, Vladimir Rusinov <vladimir@greenmice.info> wrote:
 
How can I check if all indexes in my database is valid, how to show the invalid ones (and rebuild them)?
Any quick solutions?
 
How do you define whether and index is valid or invalid?

--
Regards,
Richard Broersma Jr.