Re: tuning a query on union

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 7 Dec 2001 22:35:02 -0000
Message-ID: <1007764420.17016.0.nnrp-01.9e984b29@news.demon.co.uk>

Your original statement was

"the tables are pretty much identical"

Although the columns in the select lists had the same name, I assumed that there
were differences that were not visible.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

NetComrade wrote in message <3c110ef6.605686731_at_news.globix.com>...


>don't my tables qualify as identical?

>

Received on Fri Dec 07 2001 - 16:35:02 CST

Re: tuning a query on union_all view..