Creation of indexes, Database Management System

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







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
Related Questions
Define Outer join Outer join - If there are any type of values in the one table that do not have corresponding value(s) in the other, in an equi-join which will not be selected

(a)    Provide the description of the following ODMG schema in the Object Definition Language (ODL). (b)   Based on the above object database, write the following queries i

Lost Updates : Suppose the two transactions T3 and T4 run simultaneously and they happen to be interleaved in the following way (suppose the initial value of X as 10000):

Improved Reliability: In a centralised DBMS, a server failure stops the operations of the DBMS. Though, a failure at single site of a DDBMS, or a failure of a communication link cr

The traffic data mgmt. systems infrastructure plan describes the software, hardware, data network, and other elements that will support the TDMS. The infrastructure plan is based o

Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized.

how can apply joins on table

By using the delete operation some consisting records can be deleted from a relation. To delete some definite records from the database a condition is also specified based on which

What is a hash index? A hash index organizes the search keys, with their associated pointers, into a hash file structure.

Fundamentals of Database Management 1. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? 2. With a necess