Post reply

Indexes creation

  • March 27, 2014 at 8:23 am

    #287043

    Hi all,

    I need to find all the index and the creation date. I did cross apply of sys.objects & Sys.indexes on name column. I am getting some but the team is saying they created so many. Please let me know is there another option to find Indexes and their creation date? If you have anything please provide me the script.Thank you

  • March 27, 2014 at 8:37 am

    #1700716

    I'd seen several similar posts on finding index creation date.

    i'm very sure that there is no creation date exposed anywhere for indexes; objects in sys.objects have the create_date and modify_date, but it's not the same in sys.indexes; i'm not sure if the data is even captured int eh resource database, but i'm sure it's not exposed or available.

    you might find it in the default trace for recently created indexes, but it's not permenantly captured .

    you could also create an extended event or trace to capture the information going forwatd.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 27, 2014 at 6:50 pm

    #1700949

    Lowell (3/27/2014)

    I'd seen several similar posts on finding index creation date.

    i'm very sure that there is no creation date exposed anywhere for indexes; objects in sys.objects have the create_date and modify_date, but it's not the same in sys.indexes; i'm not sure if the data is even captured int eh resource database, but i'm sure it's not exposed or available.

    you might find it in the default trace for recently created indexes, but it's not permenantly captured .

    you could also create an extended event or trace to capture the information going forwatd.

    What this query ? I was searching one times and I think data were right there . Statistics are included also.

    select crdate, i.name, object_name(o.id)

    from sysindexes i

    join sysobjects o ON o.id = i.id

    order by crdate desc

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply