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: Query rewrite

Re: Query rewrite

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sat, 16 Jul 2005 00:02:40 +0200
Message-ID: <42d83280$0$21462$ba620e4c@news.skynet.be> 






"Ryan S" <rshevchi_at_vt.edu> wrote in message 
news:1121453783.651313.19790_at_g14g2000cwa.googlegroups.com...


> Yes I did, they are all range scans or unique scans.  I would post the

> plans here if I could.

>




How about using materialized views ? Is the table data constantly changing 
or rather static ?




Matthias 
Received on Fri Jul 15 2005 - 17:02:40 CDT












Original text of this message













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