Interview Questions
1. What all database objects can be configured with Data compression?
Data compression can be configured for the following database objects:
- A whole table that is stored as a heap.
- A whole table that is stored as a clustered index.
- A whole non-clustered index.
- A whole indexed view.
- For partitioned tables and indexes, the compression option can be configured for each partition, and the various
partitions of an object do not have to have the same compression setting.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment