Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • The Generated case Expand/Collapse control lets you hide or display the hint-based cases and transformation-based case generated for a statement.
  • The Perform detail analysis and Execute each generated case check boxes let you enable multiple statements or cases for simultaneous execution while the Run/Cancel Job controls let you start and stop simultaneous execution.
  • Use the Schema and Catalog Selectors to Selector to select a schema and catalog for the tuning job.
    The catalog selector is available only for SQL Server data sources. By specifying the schema and catalog, the tuner can use the paths path of the schema and catalog selected to find the tables queried in the job rather that use the paths path of the schema and catalog used to connect to the data source. If you change the schema or catalog used in a tuning statement you will need to refresh the tuning statements in order for new cases to be generated, which take into consideration the schema used. Right-click a tuning statement, and then select Refresh Tuning Statements.

...

You can compare cases between an original statement and one of its tuning-generated statements, or another statement case via the Compare to Parent and Compare Selected commands, respectively.
Image Modified


To compare a case side-by-side with its parent

...

  1. On the Overview tab of a tuning job, right-click in the Name field of a case and select Create Outline from the context menu.
    A NewOutline wizard opens.
  2. On the first panel, provide an Outlinename, select an Outlinecategory, and then click Next.
    A Preview Outline panel opens previewing the SQL code to create the outline. 
  3. Select an Actiontotake option of Execute or OpeninnewSQLeditor and then click Finish.
    For more information, see Using the Outlines tab.



Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse