Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: How would you find out whether a SQL query is using the indices you expect?

    Hello, everyone:

    This is testing question from a tesing seb site. Any reply will be appreciated.

    ZYT

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Read Books Online or a good book on SQL Server like SQL Server Performance Tuning Technical Reference.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  3. #3
    Join Date
    Oct 2003
    Location
    Newcastle, Australia
    Posts
    51
    Search books online for "execution plan"

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Look at the execution plan in QA

    This is a testing answer from a non testing website ... any question will be appreciated.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

Posting Permissions

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