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?
On Mon, 27 Oct 2003 22:30:08 -0500, "Scott Watson"
<nospam_at_hotmail.com> wrote:
>
>The problem is **not** the query statement. The statement is tuned.
>No histogram will make the query I provided any faster.
You are wrong. The statement as it is doesn't make sense. You should, as I already pointed out, turn the inline view into a simple exists subquery. Problably you don't know the difference between inline views and subqueries, but that's your problem.
-- Sybrand Bakker, Senior Oracle DBAReceived on Mon Oct 27 2003 - 22:28:30 CST