Database Administrator (DBA) Question:
Give the reasoning behind using an index.
Answer:
Faster access to data blocks in a table.
| Previous Question | Next Question |
| Compare and contrast TRUNCATE and DELETE for a table. | Give the two types of tables involved in producing a star schema and the type of data they hold. |