Interested to Buy Any Domain ? << Click Here >> for more details...
How many different types of indexes we have in oracle?
- 24 Answers
- 192693 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 is IDE,DMV in sql server?
How to define a record variable to store a table row?
What is the difference between Delete, Truncate and Drop in Oracle?
What is materialized view in Oracle?
What are the components of logical database structure in oracle database?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is background process in Oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Design database draw er diagram for a certain scenario ?
How to do clean up if create database failed?
How to enter a new row into a table interactively?
What is the difference between formal parameters and actual parameters?
How do we display rows from the table without duplicates?
How to convert a date to char in oracle? Give one example.
Explain what are clusters?
