This content has been marked as final. Show 6 replies
may be one of them does not have the same number of indexes of the other one .
There is no data in the both tables!
Than what index can do?
Edited by: Srinivas M. P. on Jan 3, 2013 5:22 PM
even table1 taking lesser time to show the result .then , what result ?
Result is always 0 rows
what is the difference of time frame between both the tables?
Yes, it is possible.
If you populate table1 with many rows (10 million or above) and then delete all rows (be sure to make DELETE not TRUNCATE) and make TRUNCATE on TABLE2 then response time will be different even both tables contains no data. For TABLE1 all empty blocks must be read, while TABLE2 contains only 1 block to read. Read about High Water Mark for details.
Nice dear :)
It is clear