Post reply

Proper indexes on tables

  • March 23, 2010 at 2:05 pm

    #139943

    How do I see if there are proper indexes on the tables in a database?

  • March 23, 2010 at 2:12 pm

    #1138541

    I suppose that all depends on what you mean by "proper indexes". Are you looking for a list of indexes on all tables? Are you looking for indexes to support a certain operation/set of operations? Are you trying to do some performance tuning?

    Perhaps you can give us a bit more detail about what you are looking for and we'll be able to help.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • March 23, 2010 at 5:43 pm

    #1138614

    It will depend on your knowledge of the code running against the database. Check your execution plans.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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