How the optimizer analyzes a query sybase?

The optimizer sql server examines each clause of the query and determines if it can be useful in limiting the amount of data that must be traversed, ie, if the clause is useful as search argument (SARG) or as part of the criteria for marriage . A clause used as a search argument is referred to as sargable or optimizable and can make use of an index for faster recovery. A SARG limits a search because it specifies an exact match, a range of values ​​or a combination of two or more items joined by AND logic function. The use of clause SARG may use an index for more rapid recovery of information. However, an expression that is not sargable can not limit the search, so an index is not useful for these expressions

so does the sybase?

asked 29 Jan '13, 19:43

Walmir%20Taques's gravatar image

Walmir Taques
600283143
accept rate: 13%


Have a look at this section in the documentation on "How the optimizer works"

permanent link

answered 29 Jan '13, 20:04

Mark%20Culp's gravatar image

Mark Culp
22.6k9129265
accept rate: 40%

Ok.thanks.

(29 Jan '13, 21:01) Walmir Taques
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×27

question asked: 29 Jan '13, 19:43

question was seen: 509 times

last updated: 29 Jan '13, 22:21