COMPUTER SCIENCE AND ENGINEERING
COMPUTER ORGANIZATION
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You can think of it as a one column table
|
|
Serial
|
|
|
Indexed Sequential
|
|
|
Direct Access
|
|
|
Sequential
|
Explanation:
Detailed explanation-1: -Single-Column Indexes A single-column index is created based on only one table column. The basic syntax is as follows. CREATE INDEX index name ON table name (column name);
Detailed explanation-2: -Multi-column indexes are created on a single table, with each index containing two or more columns. Multiple indexes can improve the performance of queries that use different combinations of columns. A single index can be used to optimize queries that use multiple columns.
There is 1 question to complete.