Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Unique Index on a view

Re: Unique Index on a view

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Wed, 22 Nov 2000 00:08:26 GMT
Message-ID: <3a1b0e68.84663390@news.alt.net> 






On Tue, 21 Nov 2000 16:46:55 -0500, "oralap" <nospam_at_nospam.com>
wrote:



>You can't index a view, and it's not necessary in this case.  The UNION

>operator performs a DISTINCT on the merged result set from the two queries.

>




That's why I did a UNION ALL.



Brian
Received on Tue Nov 21 2000 - 18:08:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US