Display INDEX_NAME, LAST_ANALYZED and DAYS_AGO by having the difference between the last analyzed date and the current date from the all_indexes view.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Answer by harbingergroup · May 17 at 06:57 AM
select owner, index_name, last_analyzed, global_statsfrom dba_indexeswhere owner not in (‘SYS’,’SYSTEM’)order by owner, index_name
Answer by anthony.green · May 14 at 07:25 AM
ALL_INDEXES is an Oracle, thing, you would just get the information you need by selecting the right pieces from the view along with using date math (lookup DATEDIFF) for this.
Answers Answers and Comments
16 People are following this question.
Migrate sql2000 db to sql2008 db
How to List Invalid objects(SP,Functions,View, Triggers) in SQL Server 2000?
Dynamic SQL While Loop Not Executing
how to build constraint on table depend on other table on sqlserver2000
SQL 2000 tunning nightmare