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: Sample question about views and indexes

Re: Sample question about views and indexes

From: Abu M Rahman <arahman_at_nko.com>
Date: 1997/12/19
Message-ID: <349AD035.2C2C0006@nko.com>#1/1 







If there is a index match in the table : YES it uses index



Marc Brevet Lepreux wrote:



> does Oracle use table's indexes when I select a rows by a view of this

> table?





--
-------------------------------------------------------------------
Abu M Rahman                     | PHONE: (904) 737-3181 ext. 237
Database Administrator           | FAX  : (904) 739-1984
NKO, Inc.                        | Email: arahman_at_nko.com
-------------------------------------------------------------------


Received on Fri Dec 19 1997 - 00:00:00 CST












Original text of this message













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