What is an Index ? How it is implemented in Oracle Database ?
- 4 Answers
- 10764 Views
- I also Faced
- E-Mail Answers
Answer Posted / sawant
An index is a database structure used by the server to
have direct access of a row in a table.
An index is automatically created when a unique of primary
key constraint clause is specified in create table comman
(Ver 7.0)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to insert multiple rows with one insert statement in oracle?
How to view existing locks on the database?
Explain the use of indexes option in imp command.
How to Truncate Table in Oracle
What is an oracle table?
How to end the current transaction in oracle?
Is there a combination of "like" and "in" in sql?
What is the difference between 10g OEM and 11g OEM?
What is a system tablespace?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Difference between cartesian join and cross join?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is the maximum number of triggers that can be applied to a single table?
Explain the dml?
What are the predefined tablespaces in a database?
