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 and/or Partitions, Performance Consideration ?

Re: VPD and/or Partitions, Performance Consideration ?

From: Micha³ Kuratczyk <kura_at_lj.pl>
Date: Thu, 17 Aug 2006 16:03:21 +0200
Message-ID: <ec20p8$ih$1@mx1.internetia.pl>


krislioe_at_gmail.com wrote:
> Is there any docs from oracle about performance impact of applying VPD
Well, generally you just write a procedure that adds predicates to WHERE clause. So the performance depends on:
- your queries with added predicates (and therefore: you) - your procedure (and therefore: you)

I think you can ignore the performance impact of the Oracle internal mechanism that causes your procedure to add predicates to your query. It's minimal compared to the mentioned two factors.

-- 
Michal Kuratczyk
Received on Thu Aug 17 2006 - 09:03:21 CDT

Original text of this message

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