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
Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

Question: In relation to distributed database answer the following questions: (i) Give a brief definition of distributed database. Support your answer with an appropriate di

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

how to write tables and drow E-R diagrams for hosiptal management system and how to normalize and cardinalities?

Update Anomaly : This anomaly is occurred due to data redundancy. Redundant information makes updates more complex since, for example, varying the name of the instructor of MCS-014

What is OMR? OMR (Optical Mark Recognition) is the translation of marks - or the absence of marks - but not the shape of the mark on forms that have small circles ("also called

The PROJECT operation The project operation is used to choose the records with specified attributes as discarding the others based on some related criteria. This is denotes as ∏

using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat