<<Previous Next>>
Oracle -
Explain how to list all indexes in your schema - April 10,
2009 at 11:00 AM
Explain how to list all indexes in your
schema.
The list of all indexes in a schema can be obtained through the
USER_INDEXES view with a SELECT statement:
SELECT index_name, table_name, uniqueness
FROM USER_INDEXES WHERE table_name =
'tablename';
Also read
Schema represents structure of the database. Database has two
main types of schemas partitioned : Physical schema: Describes the
database design at the physical level.............
The list of all indexes in a schema can be obtained through the
USER_INDEXES view with a SELECT statement:...........
Schema objects are the logical database structure that represents
database's data. Schema objects include tables, views, sequences,
synonyms, indexes, clusters, database............
Archiving is the process of removing of old data and unused data
from the main databases. This process keeps databases smaller, more manageable
and thus acquires..............
| 
