Re: db_file_multiblock_read_count and performance

Since the table was created with out indexes,
and the SQL was hinted to FULL(), there really
was no choice other than FTS.

On Tue, 07 Dec 2004 15:05:22 +0000, ryan_gaffuri@xxxxxxxxxxx
<ryan_gaffuri@xxxxxxxxxxx> 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.
> --

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: