Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: VPD vs Multi Schema vs Partitioning
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