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
Last modified: 2016-07-02 19:34:51