optimizer Image

optimizer

question
borispinsky avatar image
borispinsky commented Default

Does cost threshold for parallelism parameter could influence on serial plans without changing it to Parallel?

performance performance-tuning parallelism optimizer

0 Likes

0Answers

4 Comments

question
ThomasRushton avatar image
ThomasRushton answered Default

SQL Query Optimization

query sql query optimization sqlserver2008 optimizer

This question has an accepted answer. Accepted

1 Like

1Answer

1 Comment

question
zillabaug avatar image
zillabaug commented Default

what is the best way of handling tables with no clusterd index?

sql-server-2000 performance-tuning query-analyzer optimizer

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
eghetto avatar image
eghetto commented Default

Optimizer plays havoc with tally numbers

sql server 2008 r2 inline-table-valued-function optimizer tally

This question has an accepted answer. Accepted

2 Likes

1Answer

0 Comments

question
Kev Riley avatar image
Kev Riley commented Default

Why is index scan run on outer join when not using "SELECT TOP"

top outer-join optimizer scan-event

0 Likes

1Answer

7 Comments

question
SQL Kiwi avatar image
SQL Kiwi answered Default

SQL 2008 Row_Number SLOW with variables, FAST without

sql-server-2008 ranking optimizer

This question has an accepted answer. Accepted

2 Likes

4Answers

0 Comments

question
yaqubonnet avatar image
yaqubonnet asked Default

SQL Server - How do redundant indexes impact query performance?

sql-server-2008 performance indexes optimizer

This question has an accepted answer. Accepted

0 Likes

1Answer

0 Comments

question
thecoop avatar image
thecoop asked Default

Oracle v SQL Server CBO

optimizer culture

1 Like

2Answers

0 Comments

8 Posts
8 Users
0 Followers

Topic Experts

There are currently no experts identified for this topic. Can you answer questions in this topic area? Community members who provide answers that are marked as correct earn reputation and may become recognized as topic experts.