Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index ? How it is implemented in Oracle Database ?
- 4 Answers
- 11620 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / ankur jain
An Index is nothing, it is something like the index behind in your text book, using index we can find any topic in our text book very fast,, hence database index is also like that, oracle engine uses this index to find any particular row quickly..
This is automatically created when you create the primary key during creation of table..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / nishi
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 ? | 0 Yes | 0 No |
Can a field be used in a report without it appearing in any data group ?
How do we know whether an index is created on a table ???
how to get the no employee in each department including the dept which has 0 employee
Can a Tablespace hold objects from different Schemes ?
What is the disadvantage of User defind function?
How to create a new table in oracle?
defination of bitmap index
how many columns can a plsql table have
How to write a query with a full outer join in oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is a sub query? Describe its types?
What privilege is needed for a user to delete rows from tables in another schema?
Oracle General 
