Explain an index?
- 1 Answers
- 1202 Views
- I also Faced
- E-Mail Answers
Answer / Akhilendra Kumar Pandey
An index is a database structure used to speed up the retrieval of rows from a table based on one or more columns. It works by storing the value of the indexed column(s) and a reference to the row's location in the table. When a query uses the indexed column(s), Oracle can quickly find the relevant rows without having to scan the entire table.
| Is This Answer Correct ? | 0 Yes | 0 No |
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
What is oracle data type?
What is meant by redo log buffer ?
How to define default values for formal parameters?
Shall I get Pro*C Compiler in Oracle-10g release ?
How to apply filtering criteria at group level in oracle?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
How to find no of saturdays in a month using single sql ?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
What is a Public Synonyms ?
How to create a single index for multiple columns?
What is meant by a deadlock situation?
Oracle General 
