A guideline to select indexing technology for Relational Database Management Systems

Indexing techniques are utilized for the process of retrieving information form databases. This research presents a comparison among the indexing techniques used in different Database Management System to provide a guide for database developers and DBAs for selecting a suitable indexing technique which is required for the data under consideration .Furthermore, we have compared the results between different types of indexing techniques in Oracle and MS-SQL Server. Even it is very difficult to compare between these two different types of platforms. Finally, after run our experimental tests on these environments, we noted that some indexing techniques in Oracle is faster than MS-SQL server and vice versa, depending on the table size, column selected in the index and SQL statement.