Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: view-optimizing
when you create the view make sure to include a hint statement indicating what indexes are on the underlying tables. The cost-based optimizer will then use them. Received on Thu Jan 11 2001 - 08:35:11 CST