Working Of Indexes Oracle 10g
Journal: INTERNATIONAL JOURNAL OF COMPUTERS & DISTRIBUTED SYSTEMS (Vol.2, No. 1)Publication Date: 2012-11-15
Authors : Navpreet Singh;
Page : 78-87
Keywords : Index; B-tree Index; Bitmap Index; Database; RDBMS.;
Abstract
Oracle 10g is one of the best Relational Database Management System used for managing the database in an effective way. One of the important tasks in database management is improve the query performance . Oracle includes number of data structures to fast or improve the queries. One of them is indexes .Indexes are provide a faster access of tables. Oracle 10g uses indexes to avoid the full table scans. Oracle provides several indexes those improve the performance of the queries.
Other Latest Articles
- Information Extraction from Pre-Preprinted Documents
- An Efficient Density based Improved K- Medoids Clustering algorithm
- Implementation of DSR Protocol by Using Distributed Cache Update Algorithms
- A Modified & Extended Security Quality for Requirements Engineering (SQUARE) Methodology into Standard Life-Cycle models
- QUANTUM CRYPTOGRAPHY: A NEW GENERATION OF INFORMATION SECURITY SYSTEM
Last modified: 2016-07-02 19:34:51