Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index ? How it is implemented in Oracle Database ?
- 4 Answers
- 11613 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
Index is an Oracle SQL object which we create to speed up
the query performance.
It is created automatically on those columns which contains
primary key or unique key.
We can also create the index manually by using create index
command.
Max 16 indexes can be defined per table.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is the scenario where you take the database to NoArchivelog mode?
what are the default admin accounts in Oracle 10g ?
What are the built-in functions used for sending Parameters to forms ?
How many types of tables are there in oracle?
what is the use of system.effective.date variable in oracle?
What is the difference between PFILE and SPFILE in Oracle?
How do I start tns listener?
How can we create the complete backup of data in the oracle.
What are the components of logical database structure in oracle database?
What is oracle in java?
Hi Can any one tell me what are the API's used in requisition import.
How to turn on or off recycle bin for the instance?
What are the different types of record groups in oracle? Explain each of them
What is the difference between alert log file and tarce file ?
How to rename an existing table?
