By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,265 Members | 1,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,265 IT Pros & Developers. It's quick & easy.

How good to use Partition table?

OraMaster
100+
P: 135
Hi All,

I have one table with around 5 million records in it. I am thinking of making it as partitioned table. I have never did this thing before. I just want to know from experts like you that would it be good to use partitioned table in this case to improve select queries performance and also pls tell me how it will effect on insert/update/delete operations.

Thanks in advance

Regds,
Bhushan
Oct 7 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.