Re: db_file_multiblock_read_count and performance

If you read my post you should have seen that the extract from the tkprof output of my testcases showed the query plans and it was a FTS in both cases. There was no other plan available anyway since the single table in the sql didn't have any indexes.

ryan_gaffuri_at_comcast.net wrote:

> To those of you who posted test cases with different level of performance based on the DFMRC. Did your query plan change? I know this parameter can affect query plans, but if you are doing a straight full table scan, I did not notice any performance difference with different settings. I only noticed differences if my plan changed.
> I was looking to test whether it actually increases the pipe to the hard drive.
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l