Knowledge Measure

  1. True or false: If you view the execution plan for a query against a partitioned view and see unnecessary partitions listed in the plan, you have probably discovered a bug and should call Microsoft.

  2. What does an Executes column of 0 for a given query plan step indicate?

  3. True or false: In order to ensure maximum query performance, the CHECK constraints that define the partition column for a partitioned view must not overlap.

  4. Describe the purpose of the partitioning column in a partitioned view.

  5. True or false: The SQL Server query optimizer can eliminate unneeded partitions from a query against a partitioned view at compile-time as well as at runtime.

  6. True or false: Although it may be possible to force the optimizer to eliminate unneeded ...

Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial