[chrisplough]

Just linking in a related post that discusses some great performance improvements that Ian Lo achieved through tuning:

http://www.otmfaq.com/forums/f27/otm...rovements-515/ (OTM 5.5: VPD Query Performance - Improvements)

Another about some performance issues when a VPD profile is used:

http://www.otmfaq.com/forums/f28/vpd...erformance-25/ (VPD profile has negative effect on query performance)

and some negative affects of changing the VPD granularity:

http://www.otmfaq.com/forums/f21/sol...ularity-d-219/ ([SOLVED] VPD Context with VPD_GRANULARITY=D)

--Chris