ASE 12 0 Changes From Query Text

ASE 12. 0 Changes

From Query Text to Query Results

Work in progress

What do the icon’s mean? ?

Does it all go faster?

From Query Text to Query Results

Join Transitive Closure

Join Transitive Closure

ANSI Joins

Example - Inner Joins

Example - Outer Joins

ANSI Join Terminology

Nested Joins

Name Scoping Rules

Views & Outer Joins

Predicate Transformation

Example

Predicate Transformation Internals

Predicate Transformation Internals

From Query Text to Query Results

LIKE

Better Selectivity Estimates For Like Clauses

Abstract Query Plans

Can Better Be Worse Than Good?

Curing Unexpected Behavior

Abstract Query Plans

Where will AQP’s be used?

How are the plans created?

What Do Abstract Plans Look Like?

From Query Text to Query Results

Why sort-merge joins ?

Example

Merge Join Internals

Merge Joins in ASE 12. 0

Full Merge Join MJ Table R Table S

Full Merge Join

Left Merge Join LMJ Worktable Table S Table R Worktable

Left Merge Join

Right Merge Join RMJ Worktable Table R Worktable Table S

Right Merge Join

Sort-Merge Join SMJ Worktable 1 Worktable 2 Table R Table S Worktable 1 Worktable 2

Sort-Merge Join

Cost Model

Restrictions on Sort/Merge Joins

50 Table Limit

Are you nesting loops 50 deep?

50 Table Limit

50 Table Limit

Execute Immediate

Enables variable syntax if required

Static and Dynamic Context

Security Issues

Restrictions

Where/how it cannot be used?

From Query Text to Query Results

Summary