Computer-Networks
August 28, 2024SQL
August 28, 2024SQL
| Question 123 |
Consider the following query :
SELECT E.eno, COUNT(*)
FROM Employees E
GROUP BY E.eno
If an index on eno is available, the query can be Solutioned by scanning only the index if
SELECT E.eno, COUNT(*)
FROM Employees E
GROUP BY E.eno
If an index on eno is available, the query can be Solutioned by scanning only the index if
| the index is only hash and clustered
| |
| the index is only B+tree and clustered | |
| index can be hash or B+ tree and clustered or non-clustered | |
| index can be hash or B+ tree and clustered |
Correct Answer: C