March 11th, 2004, 04:52 AM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 6
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Optimize a query
Code:
SELECT c_rrn, c_pan
FROM (
SELECT *
FROM gvsa.tgvs32_tra, gvsa.tgvs30_esi_tra, gvsa.tgvs31_esi_val, gvsa.tgvs33_soc
WHERE d_ora_arr >= TO_DATE('11032003000000', 'DDMMYYYYHH24MISS')
AND d_ora_arr <= TO_DATE('11032004114123', 'DDMMYYYYHH24MISS')
AND gvsa.tgvs30_esi_tra.c_esi_tra=gvsa.tgvs32_tra.c_esi_tra
AND gvsa.tgvs31_esi_val.c_esi_val=gvsa.tgvs32_tra.c_esi_val
AND gvsa.tgvs33_soc.c_soc=gvsa.tgvs32_tra.c_soc)
ORDER BY c_rrn
for a PHP application I need to paginate my data (10 rows per page) and so I fetch first ten rows in an array, break when $index=10, but this query gets many system resources..
can U help me??
thanks!
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
