Idea for "self-tuning" database
- From: "Boivin, Patrice J" <BoivinP@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Apr 2004 15:03:39 -0300
With the penchant some people have for using layers of views with multiple
complex joins and subqueries instead of tables, I am wondering if in 10g (or
later) the database is going to start looking at the number of views
referring to views, or statements going through synonyms and db links in its
execution plan analyses.
And if roles turn out to be slower than sys and obj privs, then perhaps take
that into consideration as well.
Patrice.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » Idea for "self-tuning" database
