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: oralap <nospam_at_nospam.com>
Date: Tue, 21 Nov 2000 16:46:55 -0500
Message-ID: <j3CS5.1922$Sl.96892@iad-read.news.verio.net> 






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.




See http://www.lonyx.com for links to Oracle sites, scripts, and tips.
Received on Tue Nov 21 2000 - 15:46:55 CST












Original text of this message













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