| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Tuning views
Hey all,
We have a multitable view setup on our 8.1.7.2.0 HP/UX 11.0 DB for security, so our users can use <gulp> MS Ack-sess to query a few columns from some sensitive tables. In other words, the view doesn't filter rows, just columns. The problem is that the author of the view explicitly set the RULE hint and it seems to be causing a few performance problems when joining the view to other tables.
So, I'll "fix" the view and be the hero, right? <sigh> Well, how do you tune a multitable view when you don't know how it's going to be used? After fixing a little join mishap, I added hints for FIRST_ROWS, as well as FULL for the super small 1-block tables. This seems to me to be valid, since the users of the view will (hopefully) filter the rows based on an index of one or more of the tables of the view, but I don't really have any proof other than a pretty-looking explain plan.
Anyone have a philosophy or procedure for tackling something like this? Preferrably one that ends in "drink beer"?
TIA!
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jun 28 2002 - 14:56:17 CDT
 |
 |