Re: VPD vs Multiple Schemas

Thanks Tom for pointing.

Thanks Jonathan once again for wonderful suggestion. I have few queries...

>>If you can afford the cash, then the optimum strategy is list-partition tables

If we go for VPD also then enterprise edition is needed and partitioning option is available in Enterprise edition. So what are the extra expenditure if we use partitioning?

What I see benifit over normal VPD and using this option is that performance issues comeup in VPD will be avoided to great extent. Other Advantages/Disadvantages remains the same for VPD and list-partition tables. Could you please put some light If they are any extra?

Now I have created presentation for 3 options: VPD, Filtering data using view for each table and Multiple schema's.

I had trial round of presentation with few managers and they found Multiple Schemas option tempting? Next week I need to present this to management, so please help me with your inputs.

Thanks & Regards,

Shailesh Received on Thu Oct 12 2006 - 04:41:10 CDT