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
Compute the closure (F+) for the following set of the functional dependencies defined on R(a,b,c,d), where F - {c→ a, ab → d, a → b, d → c}, i.e. what are all of the FDs implied b

Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person.   Derived  Attributes that are not stored directly but can be derived

Can you help me with the following: Drop statements for all objects in the lab project. Create statements for all objects of the lab project Create indexes for foreign keys Cre

What are stored-procedures? And what are the advantages of using them? Stored procedures are database objects that perform a user defined operation. A stored procedure can have

Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o

What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.

Ask q“A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded wher

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→ a, be → c, ac → e, b → f, f → d, a → c}. a. Is the following decomposition i) non