What is an Index ?
Answers were Sorted based on User's Feedback
Answer / rahul
indexing a table is access stretagy. its a way to sort and
search record in the table. its a faster way of retreving
records.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / orawhiz
An Index is an optional structure associated with a table to
have direct access to rows,which can be created to increase the
performance of data retrieval. Index can be created on one
or more columns of a table.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is the difference between substr and instr?
What are the set operators union, union all, minus & intersect meant to do?
what diffrence between function and procedure?
What is trigger associated with the timer ?
Can we create more than one index on particular column?
Is primary key indexed by default in oracle?
How to enter a new row into a table interactively?
What is partitioned table in Oracle?
how to retrieve data from different tables ,place this data in different excel worksheets.
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
how to genarate random numbers in oracle for particular row?
State the various uses of dbcc command?