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
Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr

What are three components of the schema architecture proposed by ANSI/SPARC? The three component schema architecture proposed by ANSI/SPARC is as given below: External sche

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 is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only

Whta is the advantage of the database management approach? The advantage of the database management approach is data is integrated and can be accessed by multiple programs.

We will explain here an example database application having COLLEGE database and use it in showing several E-R modelling concepts. College database remains track of faculty, Stu

State the terms Designing the database and Normalization Designing the database: Out of the ERD we have formed, it is very easy to verify the tables, the attributes which the

Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri

What is Functional Dependency? A Functional dependency is shown by X Y among two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple