Database Reference
In-Depth Information
Figure 21.8
Querying
USER_INDEXES
and USER_IND_
COLUMNS.
USER_CLU_COLUMNS
. Describes all columns in constraints.
USER_CLUSTER_HASH_EXPRESSIONS
. Hash clustering
functions.
The script executed in Figure 21.8 matches indexes and index columns
for the currently logged-in user. The script is included in Appendix B.
This chapter has described both indexing and clustering. Indexes are of
paramount importance to building proper Oracle SQL code and general
success of applications. The next chapter covers sequences and synonyms.
21.4
Endnotes
1.
Oracle Performance Tuning for 9
i
and 10
g
(ISBN: 1-55558-305-9)
2.
Oracle Performance Tuning for 9
i
and 10
g
(ISBN: 1-55558-305-9)
