How we can Improve the Performance of a Query WIthout creating Indexes

  • Hi,

    Greetings!!!

    How we can Improve the Performance of a Query WIthout creating Indexes?

  • Without more detail that is almost impossible to answer:

    a) What is the query?

    b) what indexes are there currently?

    c) Why do you not want to create indexes?

    With some of that informations available there may be some things you can do.

    Mike John

  • Hi John,

    I dont have permission to create Index.

    In Execution plan its giving Table Scan only..

    what are the other way's to improve the performance of the query?

  • If it's a table scan, there's probably an index missing. Speak with the DBA about getting the necessary indexes added.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • sarvade.inder (11/4/2011)


    Hi John,

    I dont have permission to create Index.

    In Execution plan its giving Table Scan only..

    what are the other way's to improve the performance of the query?

    To add to Gail's suggestion... there may be an index available that's not being used because of the way the query has been written. Google for "sargable sql" (without the quotes) and see one example as to why a Table Scan might be used instead of an Index Seek.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Better suggestion. Post the query and the table and index definitions.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

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