Question: [55 pts] Consider the following table with the given assumptions. Employee (Ssn, FirstName, LastName, Gender, Age, Salary, DepartmentID) Assumptions: - There is no index. -
![[55 pts] Consider the following table with the given assumptions. Employee](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f2f23665f21_74966f2f235d0fea.jpg)
[55 pts] Consider the following table with the given assumptions. Employee (Ssn, FirstName, LastName, Gender, Age, Salary, DepartmentID) Assumptions: - There is no index. - There are total 8,000,000 rows. - 250,000 rows fall within the 2,500 to 3,000 salary range. - There are 100 rows for each page. - 400 index rows fit on a non-clustered index leaf page. What is the number of page accesses of the following queries for the following cases with the given assumptions? Consider each case separately. a) [28 pts] Select Ssn From Employee Where Salary>2500 and Salary2500 and Salary
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
