Choose the correct option about the indexing of a file in database
a) It can have only one clustered index with multiple secondary indexes.
b) It can have multiple clustered indexes.
c) It can have both a primary and a clustered index.
d) All of the above.
Answers
Answered by
8
(a)
i hope u understand
i hope u understand
Answered by
1
Indexing is a technique to reduce the quantity of disk access times when a query gets processed.
An index is a data structure maintained to easily access the required data during query execution. There are two types of Indexing.
Clustered and Non Clustered Indexing.
The right thing about the indexing of a file in a database is it can have single clustered index with multiple secondary indexes. The answer is option A.
Similar questions