| Author |
Message |
    
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1269
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 3:00 pm: |    |
ok mama ippudu ardham ayindi nuvvu chepindi..thanks nenu kuda oka kotha vishayam telusukunnaa |
Pedarayudu
Pilla Bewarse
Username: Pedarayudu
Post Number: 665
Registered: 04-2007
Posted From: 129.138.18.85
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:48 pm: | |
query bane vundi.. bind variables anni enduku use chesada ani 15 mins edikithe aa inpo dorikindi.. naaku ippati daka bind variables tho execution time tagguddi ani telavadu.. only parsing ki help avuddi anukuntunnaa.. so aa side kooda bane vundi |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1267
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:46 pm: | |
nuvvu telusukunnavu saree maku cheppu mamaa emi cheyyaloooooooo |
Pedarayudu
Pilla Bewarse
Username: Pedarayudu
Post Number: 661
Registered: 04-2007
Posted From: 129.138.18.85
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:32 pm: | |
Range evaluation over bind variables
For index range execution plans, selectivity is guessed. Prior to Oracle9i, because bind variable values are not available at parse time (values are passed to the cursor after the execution plan has been decided), the optimizer cannot make decisions based on bind variable values. The optimizer assumes a rule of thumb of 25% selectivity for unbounded bind variable ranges (e.g., WHERE dept_no = :b1) and 50% selectivity for bounded ranges (WHERE dept_no > :b1 AND dept_no < :b2). Beginning with Oracle9i, the cost-based optimizer obtains bind variable values prior to determining an execution plan.
 thanks sokesh iyyala bind variables gurinchi saaana telusukunnaa.. nee query valla |
Bignole
Mudiripoyina Bewarse
Username: Bignole
Post Number: 6506
Registered: 03-2004
Posted From: 161.225.1.12
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:24 pm: | |
good catch
Fear the Spear......We are Coming for you!!!! |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1266
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:24 pm: | |
decode braces tappu vaddadu emo aythe
decode(a.q358shpd, :sys_b_000, NULL, to_date(
a.q358shpd + :sys_b_001), :sys_b_002)
edi ayi vuntundi |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 48103
Registered: 07-2004
Posted From: 162.136.192.1
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:21 pm: | |
decode(a.q358shpd, :sys_b_000, NULL, to_date(
a.q358shpd + :sys_b_001, :sys_b_002))
------
if a.q358shpd = :sys_b_000
then null
else to_date(a.q358shpd + :sys_b_001, :sys_b_002)
equal aithe null returning,equal kaakapothe em settunnadu dates tho  |
Bignole
Mudiripoyina Bewarse
Username: Bignole
Post Number: 6505
Registered: 03-2004
Posted From: 161.225.1.12
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:21 pm: | |
mama decode ee betterIN meedha
Fear the Spear......We are Coming for you!!!! |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 48102
Registered: 07-2004
Posted From: 162.136.192.1
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:19 pm: | |
decode(a.q358shpd, :sys_b_000, NULL, to_date(
a.q358shpd + :sys_b_001, :sys_b_002))
 asalikkada decode em chesthaandho kooda artham kaatalledhu sok maama... |
Bignole
Mudiripoyina Bewarse
Username: Bignole
Post Number: 6504
Registered: 03-2004
Posted From: 161.225.1.12
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:19 pm: | |
mamaakkada decode deniki vadadu? is he returning null values?
Fear the Spear......We are Coming for you!!!! |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1265
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:16 pm: | |
aa decode ni emi ayina cheyyavachaa...nenu rasina query kadu...evadoo eppudoo rasadu...manager gadu vachi aa query performance improve cheyyali emi cheyyaloo chudu annadu
 |
Bignole
Mudiripoyina Bewarse
Username: Bignole
Post Number: 6501
Registered: 03-2004
Posted From: 161.225.1.12
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:14 pm: | |
anni trim la
kaani query bagane vundhi ga
Fear the Spear......We are Coming for you!!!! |
Pedarayudu
Pilla Bewarse
Username: Pedarayudu
Post Number: 660
Registered: 04-2007
Posted From: 129.138.18.85
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 2:13 pm: | |
/* Formatted on 2007/10/02 13:07 (Formatter Plus v4.8.7) */
SELECT RTRIM (a.q358trknum),
DECODE (a.q358shpd,
:sys_b_000, NULL,
TO_DATE (a.q358shpd + :sys_b_001, :sys_b_002)
),
RTRIM (a.q358trkscd), RTRIM (c.q5lotn), RTRIM (c.q5soqs),
RTRIM (c.q5litm), RTRIM (c.q558shpn)
FROM f5841003 a, f5841004 b, f5841005 c
WHERE RTRIM (c.q5lotn) IN
(:sys_b_003,
:sys_b_004,
:sys_b_005,
:sys_b_006,
:sys_b_007,
:sys_b_008,
:sys_b_009,
:sys_b_097,
:sys_b_098)
AND c.q558shpn = b.q458shpn
AND b.q458trknum = a.q358trknum
AND a.q358intext = :sys_b_099
AND TRIM (b.q4mcu) IN (:sys_b_100, :sys_b_101)
AND TRIM (b.q4allmcu) IN (:sys_b_102, :sys_b_103yaa)
query bane vundi gaa.. limits,joins anni bane vunnayi.. |
Edo_okati
Celebrity Bewarse
Username: Edo_okati
Post Number: 9467
Registered: 03-2007
Posted From: 199.173.224.32
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 1:59 pm: | |
pdaesh raa ikkadaku vachii helping chesukooo 
Naku Chukkalese chinnaoda nee cinema hero la chinimaluo utter me gutter flop avutune untai nuvvu ape varakuu  |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1264
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 1:57 pm: | |
yaa telusu aa trim function use cheste performance tagguthundi ani....but tappadu...so query structure ela marusthee or emi chestee performance perigee chance vundi mama |
Gochi
Bewarse Legend
Username: Gochi
Post Number: 48100
Registered: 07-2004
Posted From: 162.136.192.1
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 1:55 pm: | |
 entaa trimmings anni |
Symbol_of_king
Kurra Bewarse
Username: Symbol_of_king
Post Number: 1262
Registered: 12-2005
Posted From: 198.182.163.125
Rating:N/A
Votes: 0(Vote!) | | Posted on Tuesday, October 02, 2007 - 1:46 pm: | |
SELECT rtrim(a.q358trknum), decode(a.q358shpd, :sys_b_000, NULL, to_date(
a.q358shpd + :sys_b_001, :sys_b_002)), rtrim(a.q358trkscd), rtrim(
c.q5lotn), rtrim(c.q5soqs), rtrim(c.q5litm), rtrim(c.q558shpn )
FROM f5841003 a, f5841004 b, f5841005 c
WHERE rtrim(c.q5lotn) IN (:sys_b_003, :sys_b_004, :sys_b_005, :sys_b_006,
:sys_b_007, :sys_b_008, :sys_b_009 :sys_b_097, :sys_b_098)
AND c.q558shpn = b.q458shpn
AND b.q458trknum = a.q358trknum
AND a.q358intext = :sys_b_099
AND trim(b.q4mcu) IN (:sys_b_100, :sys_b_101)
AND trim(b.q4allmcu) IN (:sys_b_102, :sys_b_103yaa
ee query performance improve cheyyadaniki ela marchavachu |
