Oracle SQL Performance Tuning Tips-Which is Faster: Indexed Retrieval or Full-table Scan?
Note : Provide your comments by clicking below options! Thanks ! :)
•Full-table scans can be efficient because they require little disk movement. The disk starts reading at one point and continues reading contiguous data blocks.
•Index retrievals are usually more efficient when retrieving few records or when using joints with other tables.
•If more than 52%, this percentage defers from table to table and depends on the physical I/O, of the table retrieved a full table scan is better.
Note : Provide your comments by clicking below options! Thanks ! :)
0 comments:
கருத்துரையிடுக