|
Vol: 48(62) No: 2 / June 2003 The Influence of Indexing on Record Reading and Writing Time in Database Tables L. Jian Department of Computer Science and Engineering, "Politehnica" University of Timisoara, 2 V. Parvan, 300223 Timisoara, Romania, phone: (40) 256-403259, e-mail: ljian@cs.utt.ro, web: http://www.cs.utt.ro/~ljian L. I. Jian Department of Computer Science and Engineering, “Politehnica” University of Timisoara, 2 V. Parvan, 300223 Timisoara, Romania, e-mail: luci@cs.utt.ro, web: http://www.cs.utt.ro/~luci Keywords: relational databases, Oracle-PL/SQL, indexed tables, database tuning, optimisation. Abstract The use of indexes in database tables leads to a huge increase in speed when performing searches on those database tables compared to sequential access to records. In this paper we analyse the influence that those indexes have on the time needed to update the tables when using SQL instructions like INSERT and DELETE. Nevertheless this time is depending on the number of records having duplicate or unique keys. References [1] * Oracle Corporation - PL/SQL User\'s Guide and Reference Release 8.1.6. [2] * Oracle Corporation - Oracle8i Application Developer\'s Guide – Fundamentals. [3] * Oracle Corporation - Oracle8i Application Developer\'s Guide - Advanced Queuing (AQ). [4] * Oracle Corporation - Oracle8i Supplied PL/SQL Packages Reference. [5] * Oracle Unleashed Second edition – SAMS Publishing 1997. [6] http://www.sqlteam.com/Forums/ |