Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index ? How it is implemented in Oracle Database ?
- 4 Answers
- 11644 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
 How to use an oracle sequence generator in a mapping?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Can we create database in oracle using command line ?
How to update a table row with a record?
How to insert multiple rows with one insert statement in oracle?
What is an oracle transaction?
How do we display rows from the table without duplicates?
What is the exact use of Collections?
Explain the use of ignore option in imp command.
What is the simplest tool to run commands on oracle servers?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How do we get field detail of a table?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to start an oracle instance?
What are a cluster and non-cluster index?
