| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Performance and Tuning Guide Volumes 1 - 3 (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 30 Abstract Query Plan Guide |
Chapter 30
This chapter covers some guidelines you can use in writing Abstract Plans.
|
| Introduction |
![[+]](/dwicons/i_expand.gif)
| Abstract plan language |
| Identifying tables |
| Identifying indexes |
|
| Specifying join order |
| Specifying the join type |
|
| Specifying partial plans and hints |
|
| Creating abstract plans for subqueries |
| Abstract plans for materialized views |
| Abstract plans for queries containing aggregates |
| Specifying the reformatting strategy |
| OR strategy limitation |
| When the store operator is not specified |
| Tips on writing abstract plans |
|
| Comparing plans "before" and "after" |
| Effects of enabling server-wide capture mode |
| Time and space to copy plans |
|
| Abstract plans for stored procedures |
| Procedures and plan ownership |
| Procedures with variable execution paths and optimization |
| Ad Hoc queries and abstract plans |
|
|