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

Home -> Community -> Usenet -> comp.databases.theory -> Are selects defined in view faster than run-time selects?

Are selects defined in view faster than run-time selects?

From: Dragan Matic <gekko_at_eunet.yu>
Date: Sun, 07 Apr 2002 10:21:11 +0100
Message-ID: <3CB00F87.3040807@eunet.yu>

    Are selects that are defined as views faster than normal selects? I am asking this because I have a big select where I retrieve data from multiple tables. Is such a select going to work faster if it is defined as a wiew. I found nowhere in literature that views are speeding up selects but I recently heard such an opinion. Received on Sun Apr 07 2002 - 04:21:11 CDT

Original text of this message

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