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.
Indexes are automatically maintained and used by Oracle.
SQL>create index test on company (cname);
Index created.
SQL>drop index test;
Index dropped.
Altering Oracle Index
SQL>ALTER INDEX ix_emp_01 REBUILD ;
-
The solution is used to copy archivelogs from RMAN catalog. Step 1: uncatalog the required archivelogs from RMAN prompt RMAN>CHANGE ARCHI...
-
How to search on Google Tip 1: Keep it simple No matter what you're looking for, try to start with a simple search like [ whe...
No comments:
Post a Comment