What is an Index ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by database schema and what does it hold?

605


WHAT IS ecc 6.0

1670


Explain drop constraint oracle?

600


What's dateware house and what's clustor with practicle example

1653


how do u setup a replication site?

1508






How to get execution path reports on query statements?

574


What to do if dba lost the system password?

608


What is the Tune Query

1857


What is a relational database management system?

687


How to rename a tablespace in oracle?

629


Why do we use bulk collect in oracle?

579


What is the minimum client footprint required to connect c# to an oracle database?

574


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1710


What is a lookup table in oracle?

553


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

1756