21. What is an Oracle index?
An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.
22. How are the index updates?
Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.
23. What are clusters?
Clusters are groups of one or more tables physically stores together to share common columns and are often used together.
24. What is cluster key?
The related columns of the tables in a cluster are called the cluster key.
25. What is index cluster?
A cluster with an index on the cluster key.
Monday, June 2, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment