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

Er model, explain the steps for reduction of er model into relational model... explain the steps for reduction of er model into relational model?

Discuss the three level architecture of dbms, PRINCIPLES OF DATABASE 1.... PRINCIPLES OF DATABASE 1. State the following terms: a) Database b) Database Management System c) Entity d) Attribute e) Relationship 2. Discuss the Three Level Architecture

Hardware failure-database recovery and security, Hardware failure :  Hardwa... Hardware failure :  Hardware failures are the failures when some disk or hardware chip fails. This may result in loss of data. One such trouble can be that a disk gets damaged and

What are wait-for-graphs, What are wait-for-graphs?Give the algorithm to co... What are wait-for-graphs?Give the algorithm to construct a wait-for-graph from a given schedule of transactions? How can deadlocks be detected from wait-for-graphs?   Ans:  The

Attribute, composite attribute composite attribute

Benefits and drawbacks of heap files, Benefits of heap files 1.   This i... Benefits of heap files 1.   This is a easy file Organisation method. 2.   Insertion is somehow capable. 3.   Good for bulk-loading data into a table. 4.   Best if file

School portal design and development, Project Description: This is going... Project Description: This is going to be a School portal to handle each activities in school such as, School fees payment, online registration and every other payment, course re

What is database trigger, What is database Trigger? A database trigger ... What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

Explain categories of failures that occur in oracle database, Explain diffe... Explain different categories of failures that occur in Oracle database? Categories of Failures - In Oracle database subsequent types of failures can occurred: Statement Failu

Describes the several relationship constraints, Describes the several relat... Describes the several relationship constraints through giving suitable example? Constraints on relationships: There are two kinds of constraints on relationships. 1) Mapping