tho.pfaff (11/21/2009)
ordinary queries grap the rows from the hard-disk, where the cpu needs more time to grap them. and erery time the sql-query is executed the a full table-scan must be performed to find the row.
It is not always true that ordinary queries fetches the rows from hard disk.
Regarding full table scan must be performed to find a row, that would be true if the company has a policy of no indexes and would never use an index ....:-) :-).
Your assumption is wrong Tommy, a full table scan happens when there are no indexes and can be avoided by having appropriate indexes..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty