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

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle table view and index

Re: oracle table view and index

From: Bert Scalzo <bscalz01_at_7-11.com>
Date: Tue, 21 Jul 1998 12:59:43 -0500
Message-ID: <6p2l6v$8lf$1@news.ses.cio.eds.com> 





It sounds like you do not understand what a view is. A view is nothing more
than a "canned query". A view does not occupy storage and cannot have
indexes. When you submit a query such as "select *
from view_name", Oracle just translates that into the query you provide
merged with the underlying view query against the actual table.



Bert Scalzo


DBA



EDS, Plano TX


Received on Tue Jul 21 1998 - 12:59:43 CDT












Original text of this message













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