Multiple Choice
One measure that determines the need for an index is the ____ of the column you want to index.____ refers to the number of different values a column could possibly have.
A) Database statistics
B) Data sparsity
C) Primary keys
D) Query optimization
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q22: Describe query optimization and the modes that
Q29: _ is another name for table space.
Q32: When setting optimizer hints,_ instructs the optimizer
Q37: All data in a database are stored
Q38: Indexes do not facilitate join operations.
Q40: Use _ to provide balance between performance
Q43: The _ is a shared, reserved memory
Q55: To generate database object statistics manually,you could
Q58: A(n)_ is a logical grouping of several
Q61: The _ cache stores the most recently