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

Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.

Problem : AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P

Explain Instance and schemas? Instances and schemas: Databases changes over time as the information is deleted and inserted. The collection of information stored in database

Question (a) Differentiate between the following terms: (i) Distributed Database v/s Distributed Database management System (ii) Homogeneous Distributed Database v/s Hete

Fragmentation: It is definite as partitioning of a relation into various fragments.Every fragment can be stored at a dissimilar site.

Object Oriented model :An object has values stored in instance variables within the object. An object also has bodies of code that execute on the object. These bodies of code are

List the SQL domain Types? SQL supports the following domain types. 1) Char(n) 2) varchar(n) 3) int 4) numeric(p,d) 5) float(n) 6) date.

How can one distinguish among different kinds of parameters? Input parameters are used to pass data to subroutines. Output parameters are used to pass data from subrout

What are the two main goals of parallelism? Load -balance multiple small accesses, so that the  throughput of such accesses enhances. Parallelize large accesses so that the res