Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Below is an example of Tuning Queries using Visual Explain Tools in Aqua Data Studio
A table, Customers2, exists in SQL Server 2012. It has no Indexes.
Before Tuning - Query Execution Plan
From Aqua Data Studio's Visual Explain Tool, you can find out that the Optimizer uses a full table scan while the query
SELECT * FROM Customers2 WHERE CompanyName='AquaFold'
is executed. Try to reduce the Query Cost by introducing an index for CompanyName
After Tuning - Introducing an Index
Table scan versus index scan
The Optimizer normally chooses a table scan if no appropriate index has been created, or if an index scan would be more costly. An index scan might be more costly when the table is small and the index-clustering ratio is low, or the query requires most of the table rows. In the example above, the Optimizer uses an Index Scan.