Consider the following scenario: A table is sorted on indexed column and has 50,000,000 rows. Each row
Fantastic news! We've Found the answer you've been seeking!
Question:
Consider the following scenario:
A table is sorted on indexed column and has 50,000,000 rows. Each row is 100 bytes.
Table and index blocks are 2 kilobytes.
Assume 1 kilobyte is approximately 1,000 bytes.
Assuming the index is sparse, how many entries are in the index?
Related Book For
Statistics For Business And Economics
ISBN: 9780321826237
12th Edition
Authors: James T. McClave, P. George Benson, Terry T Sincich
Posted Date: