Creation of Indexes

Automatically: When a primary key or Unique constraint is show in a table definition then a unique index is formed automatically.

Manually: User can form non-unique indexes on columns to speed up access time to rows.

Example: The following commands produce index on employee name and employee name + department number respectively.

CREATE INDEX EMP_ENAME_IDX ON EMP (ENAME);

CREATE INDEX EMP_MULTI_IDX ON EMP (ENAME, DEPTNO);

Finding facts about created indexes: The data dictionary have the name of index, table name and column names. For instance, in Oracle a user-indexes and user-ind-columns see contains the details about user formed indexes.

Remove an index from the data dictionary:

DROP INDEX EMP_ENAME_IDX;

Indexes cannot be modified.

Posted Date: 3/11/2013 2:30:38 AM | Location : United States

Ask an Expert

Related Discussions:- Creation of indexes, Assignment Help, Ask Question on Creation of indexes, Get Answer, Expert's Help, Creation of indexes Discussions

Write discussion on Creation of indexes
Your posts are moderated

Write your message here..

Related Questions

Write modified version of transfer that avoids deadlock, Your OS has a set ... Your OS has a set of queues, each of which is protected by a lock. To enqueue or dequeue an item, a thread must hold the lock associated to the queue. You need to implement an a

Enhanced entity relationship, what do you understand by enhanced entity-rel... what do you understand by enhanced entity-relationship

What is conceptual schema, What is Conceptual Schema? Conceptual Schema... What is Conceptual Schema? Conceptual Schema - Conceptual schema elaborates the structure of the overall database for a community of users. It hides the details of physical sto

Describe the advantage of state chart diagram, Describe the advantage of St... Describe the advantage of State chart Diagram A state chart represents a state machine, emphasizing flow of control from one state to other. A state machine is a behaviour whi

What is rigorous two phase locking protocol, Differentiate strict two phase... Differentiate strict two phase locking protocol and rigorous two phase locking protocol. In strict two phase locking protocol all exclusive mode locks taken by a transaction is

What is meant by log-based recovery, What is meant by log-based recovery? ... What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

Descrine an data dictionary, Describe an data dictionary? A data dictio... Describe an data dictionary? A data dictionary is a data structure which keeps meta data about the structure of the database ie. the schema of the database.

What is a database, What is a database? At any given time, they're sto... What is a database? At any given time, they're storing a tremendous amount of information - inventory, in the case of Amazon, messages and interrelationships in the case of Tw

What is the need for triggers, What is the need for triggers? Triggers ... What is the need for triggers? Triggers are useful mechanisms for alerting humans or for starting particular tasks automatically when particular conditions are met.

Datawarehouse, 1) Define a job scheduling strategy that will meet business ... 1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict