DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to : Index last analyzed

  1. 05-15-2001, 03:43 PM #1
    mary
    mary is offline Member
    Join Date
    Aug 2000
    Posts
    163

    Question

    Hello,
    how do you know when the index was last analyzed?
    Reply With Quote Reply With Quote
  2. 05-15-2001, 03:57 PM #2
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    select index_name, last_analyzed from dba_indexes where index_name = 'your_index_in_upper_case';


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width