In this post, we will solve Indexes – 3 HackerRank Solution. This problem (Indexes – 3) is a part of HackerRank Databases series.
Consider the following two designs to store the data using clustered indexes in MS SQL Server:
- In the first design, the fill factor is 20% and the total number of free rows per page are A.
- In the second design, the fill factor is 40% and the total number of free rows per page are B.
Which the followings describes the relation between A and B:
Solution – Indexes – 3 – HackerRank Solution
Correct Answer – A = 1.33B