Read/Write operation on indexed and non-indexed table
February 21, 2008 – 6:41 pm | by adminToday, I got a question related to database indexes. It was a tricky question which is very easy to say in words but was very difficult to say in exact or approximately figures.The question is:
if we have one million records in the table and we want to perform Read/Write operations, but in different cases. Which are:
Case 1: We have indexed table.
Case 2: We have non-indexed table.
Query:
If one query take 1 unit (time) to read from indexed table. Then
1. How much it will take from non-indexed table to read?
2. How much to write in indexed table?
3. how much to write in non-indexed table?
The answer may be approximately not exactly.
Unit may be any time: for example it may be 1 micro second.
Now the matrix is:
| Indexed Table | Non-Indexed Table | |
| Read Operation | 1 Unit | ? |
| Write Operation | ? | ? |
So, What do u say? any idea for this query?
PS: You may consider different Data base servers like SQL Server, MySql, Oracle etc. Also please cosider the Web and desktop technologies iff there is any difference. Otherwise this is general query.
Tags: Database, execution time, Read/Write Operation, Table indexes
