Synonyms and indexes, Database Management System

Synonyms and Indexes

Some of the essential properties of indexes are:

  • An Index is a schema Object
  • Indexes can be formed explicitly or automatically
  • Indexes are mainly used to speed up the retrieval of rows
  • Indexes are physically and logically independent of the table. It means they can be formed or dropped at any time and have no cause on the base tables or other indexes.
  • Though, when a table is dropped corresponding indexes are also dropped.

 

Posted Date: 3/11/2013 2:29:44 AM | Location : United States







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

Write discussion on Synonyms and indexes
Your posts are moderated
Related Questions
Attribute Preservation This is a easy and obvious necessity that includes preserving all the attributes that were there in the relation that is being decomposed.

What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

Explain DML with some examples? DML - Data Manipulation Language: statements used for managing data within schema objects. Some examples: • SELECT - retrieve data from the a da

Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO

ALTER TABLE Command : This command is used for variation of existing structure of the table in the given situation: When a new column is to be added to the table structure.

Draw an ER diagram that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled

Database Recovery And Security Introduction In this part we will introduce two main issues relating to database management systems. A computer system suffers from dissi

Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni. That uni has also many bui

CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);

The Form input elements are:             Reporter name                                                text type input             Password