How to make partitioning in Oracle more Quickly
As the table size grows and full table scans happens more frequently then there is no alternative than partitioning in oracle. Partition greatly enhance performance of a query. I will start my partitioning system simply with an example. In my database the following query took 30~35 seconds to complete. After partitioning the performance increased amazingly and it then took only 1 second. My query was, SELECT DISTINCT fs.type, fs.id , fs.pid, fs.cid , fs.cr_id, fs.created_date FROM summary fs where fs.id in (select fa.id from forms fa where fa.sar in (select la.sar from login la where la.login_id=1 and fa.created_date BETWEEN to_date('1-MAY-2008') AND to_date('21-SEP-2008') and fs.created_date BETWEEN to_date('1-MAY-2008') AND to_date('21-SEP-2008') ) )and mode=0; After seeing above query I decide to make range partition on column created_date both in summary table and forms table. Below is the list of procedur
Nice blog
ReplyDeleteThanks for your reach-out efforts. This is a great blog about RAC 10g R2 on Red Hat Linux Detail Design. Keep sharing.
I will try this. Web Hosting plays a very important role in the business world. And it is important to have the best hosting services. Buy the best Germany VPS Hosting service for your website.
This comment has been removed by the author.
ReplyDeleteReally value the blog, including the essentials of the structure. Thanks for sharing the information with us. If you want to grow your online business with secure and unmanaged Server hosting, you can purchase France VPS Server Hosting at a very low cost.
ReplyDeleteThe blog is great, so thanks for sharing your splendid blog posts, we have many online business ideas that can make your business easier for your business website hosting. Italy VPS Server Hosting
ReplyDeleteGreat tips, thank you so much for your blog.
The article you posted is very useful, impressive, and wicked. Thank you so much for posting such an information. Italy Dedicated Server
ReplyDelete