Database Administrator Guide > Database Administrator Guide > Choosing Storage Structures and Secondary Indexes > Secondary Indexes > Working with Indexes
Was this helpful?
Working with Indexes
You can perform the following basic operations on indexes:
• Create index objects
• View existing index objects, including the detailed properties of each individual object
• Drop index objects
Indexes are dropped automatically when the base table is destroyed. Indexes are also dropped when the base table is modified, unless the Persistence option is specified for the index.
In SQL, you can accomplish these tasks using the CREATE INDEX, HELP INDEX, and DROP INDEX statements. For details, see the SQL Reference Guide.
In Director, select Table from the menu ribbon.
In VDBA, use the Indexes branch for a particular table. For detailed steps, see online help.
Last modified date: 08/29/2024