Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index ? How it is implemented in Oracle Database ?
- 4 Answers
- 11468 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 |
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
what is Table ?
WHAT IS ecc 6.0
How to convert characters to dates in oracle?
State and explain about oracle instance?
definition of cluster and non-clustered index?
What is a table in oracle?
How to use null as conditions in oracle?
What is the sid in oracle?
What is difference between a formal and an actual parameter?
what are different types of locks?
State some uses of redo log files?
Oracle General 
