| Author |
Message |
    
Penkonda_tiger
Yavvanam Kaatesina Bewarse
Username: Penkonda_tiger
Post Number: 7577
Registered: 06-2005
Rating: N/A
Votes: 0 (Vote!) | | 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
|
Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa
Post Number: 20983
Registered: 03-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 25, 2012 - 4:19 pm: |
|
ee scenario loo indexes kante table_a partition chesthe help avvudhi anukuntunna baa |
Ferrari
Yavvanam Kaatesina Bewarse
Username: Ferrari
Post Number: 7010
Registered: 09-2010
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 25, 2012 - 4:16 pm: |
|
Jaffaa:yeah indexes use avuthunnaayi, i wonder if indexes are of any use.....because a.col1 and b.col1 are primary key columsn
index valla performance baga peruddi baaa
Matches:4 Batting:20 Bowling 6-1-22-2 Fielding:3 Catches
|
Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa
Post Number: 20981
Registered: 03-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 25, 2012 - 4:03 pm: |
|
yeah indexes use avuthunnaayi, i wonder if indexes are of any use.....because a.col1 and b.col1 are primary key columsn |
Stewie
Kurra Bewarse
Username: Stewie
Post Number: 1737
Registered: 03-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 25, 2012 - 3:53 pm: |
|
Jaffaa: indexes vunnaayi, rendu columns ki.
explain plan run chesi assalu indexes use avuthunnayoo ledo choodandi..
konnisarlu if more than 10% data is being accessed indexes kick off avvavu.. appudu force hint ichi choodali
Patha Signature teeseysa
|
Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa
Post Number: 20980
Registered: 03-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 25, 2012 - 3:43 pm: |
|
yeah indexes vunnaayi, rendu columns ki.....stats gather chesthunna mallaa just in case |
Stewie
Kurra Bewarse
Username: Stewie
Post Number: 1736
Registered: 03-2011
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 25, 2012 - 3:37 pm: |
|
nope.. try creating indexes if they are not present..
Patha Signature teeseysa
|
Jaffaa
Mudiripoyina Bewarse
Username: Jaffaa
Post Number: 20979
Registered: 03-2008
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, June 25, 2012 - 3:16 pm: |
|
select a.col1 from table_a a inner join table_b b on (a.col1=b.col1)
ani vundhi
table_a loo 500 million rows vunnayi
table_b loo 6 million rows vunnaayi
and b.col1 is primary key for table_b
the above query is taking very long long....
question eemiti ante if I re-write the query to something like this, would it help the performance
select a.col1 from table_b b inner join table_a a on (b.col1=a.col1)
?
result set eemanna effect avuthundhaa? |
Archives - 2012