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: VPD vs Multi Schema vs Partitioning

Re: VPD vs Multi Schema vs Partitioning

From: Mih <abczzz123_at_gmail.com>
Date: 10 Jul 2006 00:45:22 -0700
Message-ID: <1152517522.269237.80650@35g2000cwc.googlegroups.com> 





Pay attention for complicated algorithms in VPD.
Try to avoid sub-selects in VPD-generated where clauses - they do
degrade performance, you cannot control them with hints, you cannot
convert them into joins, they can change execution plans, etc...



Try to use as much as possible context variables instead.
Received on Mon Jul 10 2006 - 02:45:22 CDT












Original text of this message













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