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
What is Message switching Message switching transmits data units which can be arbitrarily long. Packet switching has a utmost packet size, if any message longer than that, it s

With the linear commit protocol, sites are connected in a chain, and the subtransaction at the left-hand end of the chain initiates the protocol. Propose a crash recovery protocol

i need to submit in this topic.

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

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

Benefits of using heuristics

what is bogus empowerment. And what is genuine empowerment

What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known

project on dbms

What are the different kinds of database end users? Discuss the major activities of each? End-Users - End-users are the people whose jobs need access to the database for que