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