Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Query optimizer for sql 2005

    One quick question.

    Is query optimizer a tool in sql that optimizes your queries? If so how do you use it?


  2. #2
    Join Date
    May 2004
    query optimizer is not a tool you can use. it's a component internal to sql server that is used to figure out what the best query plan for a given query is.

    there is a tool that will suggest indexes called "database tuning advisor". however the best tool is your own brain. or the brains of others.

    (posting your query on this forum is one way to exploit other brains for query optimization btw)
    Last edited by jezemine; 02-06-08 at 00:15.

Posting Permissions

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