| Author |
Message |
    
Stewie
Pilla Bewarse
Username: Stewie
Post Number: 782
Registered: 03-2011
Posted From: 99.32.132.46
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, December 07, 2011 - 6:22 pm: |
|
Gochi:deenekka idem hint....no parallel, forst 10 rows type hints soosaa kaani ideppudu soodale....+rule ante vicchalavidigaa nee ittamocchina rule follow aipomanaa
Oracle 8i tharvata Cost based optimization ochindi. so least resource edi aithey adi teesuko ani cheptudi database to sql engine..
dani mundu rule base motham.. appudu endi ante a index unte adi vadey .. matlada kunda.. resources debba padina parledu nuvvu mathram indexlu vadey ani
that is wat I understood .. can be wrong.. oka raayi esa
kothga petta signature ela undi 
|
Ferrari
Kurra Bewarse
Username: Ferrari
Post Number: 3848
Registered: 09-2010
Posted From: 68.32.38.13
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, December 07, 2011 - 6:08 pm: |
|
Gochi:+rule ante vicchalavidigaa nee ittamocchina rule follow aipomanaa
MOVIEART--bemmi.adi
 |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 75821
Registered: 07-2004
Posted From: 70.44.12.183
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, December 07, 2011 - 6:04 pm: |
|
Stewie:/* +rule */
deenekka idem hint....no parallel, forst 10 rows type hints soosaa kaani ideppudu soodale....+rule ante vicchalavidigaa nee ittamocchina rule follow aipomanaa
 |
Ferrari
Kurra Bewarse
Username: Ferrari
Post Number: 3846
Registered: 09-2010
Posted From: 68.32.38.13
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, December 07, 2011 - 5:55 pm: |
|
Dobbey:
enduku antha shock ayyaavu D'ey ba |
Dobbey
Kurra Bewarse
Username: Dobbey
Post Number: 4169
Registered: 03-2011
Posted From: 24.107.128.31
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, December 07, 2011 - 5:49 pm: |
|
Stewie:/* +rule */
Health is Happiness
|
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 18092
Registered: 06-2004
Posted From: 98.151.191.253
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, December 07, 2011 - 5:32 pm: |
|
Stewie:
yaa.maa daggara koda tuning valle ee hints add chestharu.. |
Stewie
Pilla Bewarse
Username: Stewie
Post Number: 780
Registered: 03-2011
Posted From: 99.32.132.46
Rating: N/A
Votes: 0 (Vote!) | | Posted on Wednesday, December 07, 2011 - 5:26 pm: |
|
If anybody is struggling with Tuning of query, one hint to try is
/* +rule */
ivala oka query with 70,000 Cost and 146K bytes had like 4 Unions and Full Table access of OE_ORDER_LINES_ALL
DBA ochi aa hint pettadu katham.. 10 sec lo ochindi before it was 30 minutes..
nenu evo mushti suggestions icha.. line_id > 400,000 type ..
kothga petta signature ela undi
|
Archives - 2011