Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images

Rate this post by selecting a number. 1 is the worst and 5 is the best.

    (Worst)    1    2    3    4    5     (Best)

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger

Post Number: 7577
Registered: 06-2005

Rating: N/A
Votes: 0

Posted on Monday, June 25, 2012 - 4:36 pm:   
Jaffaa:

table_a loo 500 million rows vunnayi
table_b loo 6 million rows vunnaayi




bedar .. try to partition table_a , and also try to use bitmap join indexes across those 2 tables , use parallel hints

this should speed up .. let me know if you need help on Partitioning
kanapade nijam: Good manners , kanapadanidhi: abusive language

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration