Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: REPOST (line wrap): How fast should an IO be on a SYMMETRIX?
How else do you want to only look at the first 100 rows from a table?
The inline view is not hurting performance.
Histograms will consider alternate plans if the data volumes call for it, and in this case the index lookup is the fastest method.
Two tables
t_mtch_subj_id 500 rows. ( I am only testing with the first 100 thus the inline view) match_data 33 million rows. (index on wb_ctry_cd, subj_id)
Need to return all columns from match_data.
Scott Watson
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1067324889.506025_at_yasure...
> Scott Watson wrote:
>
> >The problem is **not** the query statement. The statement is tuned.
> >No histogram will make the query I provided any faster.
> >
> >
> >Scott Watson.
> >
> >
> >
> On what basis can you make this statement?
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Tue Oct 28 2003 - 06:30:58 CST