Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 193421 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / rohit
In Oracle there are two types of SQL index namely, implicit and explicit.
Implicit Indexes:
They are created when a column is explicity defined with PRIMARY KEY, UNIQUE KEY Constraint.
Explicit Indexes:
They are created using the "create index.. " syntax.
NOTE:
1) Even though sql indexes are created to access the rows in the table quickly, they slow down DML operations like INSERT, UPDATE, DELETE on the table, because the indexes and tables both are updated along when a DML operation is performed. So use indexes only on columns which are used to search the table frequently.
2) Is is not required to create indexes on table which have less data.
3) In oracle database you can define up to sixteen (16) columns in an INDEX.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create a new oracle data file?
Differentiate between pre-select and pre-query?
Explain the use of owner option in exp command.
Difference between inner join vs where ?
What is user managed backup in Oracle?
What are data pump export and import modes?
How to define default values for formal parameters?
What are the advantages of oracle?
How can you merge two tables in oracle?
How to add another datafile to a tablespace?
What is the difference between postgresql and oracle?
Explain the use of control file?
Is it possible to split the print reviewer into more than one region ?
Is oracle the best database?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
