| Author | Message | ||
     Newguy123 Hero Username: Newguy123 Post Number: 18249 Registered: 01-2009 Posted From: 24.44.14.209 Rating: N/A |
nee query enni rows return chestandi total ga?. general ga ee tools first 500 rows return chestaayi. nee query kanuka 500 or less ayithe rownum use chesina ,cheyakapoina same time teesukuntadi.. | ||
| Airliner Side Hero Username: Airliner Post Number: 2344 Registered: 11-2011 Posted From: 76.10.180.33 Rating: N/A |
http://docs.oracle.com/cd/E16655_01/server.121/e15858/tgsql_ profiles.htm#TGSQL605 Great minds discuss ideas. Average minds discuss events. Small minds discuss people. | ||
| Saint Legend Username: Saint Post Number: 33913 Registered: 01-2011 Posted From: 68.13.100.193 Rating: N/A |
SQL developer lo query plan / SQL tuning advisor choosthe better query vundi vaduko antundi..! but aa query ekkada vundoo etla telusuddi? also rownum vadatam valla performance impact vuntunda? my qry was really fast if I dont use rownum.....but I was trying to get rows 11-20 in the query result set! select * from (select a.*, rownum rnum from (my actual qry) a where rownum <=> 10 naa actual qry 1 sec teesukunte....ee total qry motham 40+ sec teesukuntundi! any inputs? Ignore Spammers! |
