sharada

• May 28th, 2007

 

hi

an index like index of book enables the database retreive and present data to end user with ease.An index can be defined as a mechanism for providing fast access to table rows and enforcing constraints

this is just definition i don't know how to implement

christine

• Jun 30th, 2007

 

You can implement index lihe this:
create index [index_name] on [Table_name]

sinu

• Jul 11th, 2007

 

Index is a database object, it is used for improve table serarching operation (improve database perfomance), two types of index using oracle 1) bitmap index 2) btree index.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 17th, 2007

 

An index is a database structure used by the server to quickly find a row in a table.
In a relational database the physical location of row is irrelevent-unless, of course, the database needs to find it. In order to make it possible to find data, each row in each table is labeled with ROWid. The row id tells the database exactly where the row is located.

Indexes contain a list of entries; each entry consists of a key value and a rowid The key value is the value of a column in a row or the combination of valuesof columns in a row.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 17th, 2007

 

Indexes are used both to improve performence and to ensure uniquness of a column. Oracle automatically creates an index when a UNIQUE or PRIMARY key constarints clause is specified in a create table command.

We can manually create our own indexes via the create index command.