Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index ? How it is implemented in Oracle Database ?
- 4 Answers
- 11425 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 |
What is oracle join syntax?
Can you tell me how to add new column in existing views?how?How is possible?
what is difference between foreign key and reference key
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is the difference between Sleep and Wait? (Java)
What is the relationship among database, tablespace and data file?
What is ceil and floor in oracle?
how to get the second max val for every group in a table
What is the function of Redo Log ?
How to end the current transaction in oracle?
Explain about your project and its relation to the current job position you are applying to?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
Oracle General 
