Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index ?
- 2 Answers
- 6734 Views
- I also Faced
- E-Mail Answers
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 |
Is it possible to disable the parameter from while running the report ?
What is a shared pool?
What is a Data Dictionary ?
What is the difference between a hot backup and a cold backup in oracle?
Can multiple columns be used in group by in oracle?
Explain about functional dependency and its relation with table design?
What are the attributes that are found in a cursor?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
how many types of index?
How to create a new table by selecting rows from another table?
How to build data dictionary view an new database?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Oracle General 
