var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Scan and seek
CAn any body please tell me what are the differences between scan and seek?Which is the better way?From the query execution plan how can I get a picture about these?
In couple words:
Scan (table or index) means that table is small or condition for selecting cannot use indexes if any.
Seek (index) means that index is used for selecting rows from table.
It needs to avoid of scaning big tables (indexes).
See chapter "Graphically Displaying the Execution Plan Using SQL Query Analyzer" in BOL for details about execution plan.