Indexes – 3 – HackerRank Solution

In this post, we will solve Indexes – 3 HackerRank Solution. This problem (Indexes – 3) is a part of HackerRank Databases series.

Task

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

Note: This problem (Indexes – 3) is generated by HackerRank but the solution is provided by CodingBroz. This tutorial is only for Educational and Learning purpose.