Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 191745 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
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to store only time; not date and time?
what is the scripts in data base?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to join two tables in a single query using oracle?
WHAT IS ecc 6.0
what is the use of system.effective.date variable in oracle?
What are internal user account in oracle?
What is a sub query and what are the different types of subqueries?
What is oracle update statement with inner join ?
How to add another datafile to a tablespace?
What is integrity and what is constraint??Explain with example
How to assign a table row to a record variable?
What is logical backup in oracle?
