MVSFORUMS.com

[satyenderd]

Hi all,

I have to unload the table which is containing around 750 million data.
When I am running the following query it is taking lot of time.
Could anyone suggest the simples query to extract the data?

Thanks in advance.


herein is the query.

SELECT *
FROM table1
WHERE RID IN
(SELECT RID
FROM table2
WHERE RDNDTE IN
(SELECT RDNDTE
FROM table3
WHERE DATE(RDNDTE) >= CURRENT DATE - 5 YEARS;
_________________
Satya

[vkphani]

satyenderd,
First run your inner query and pass these results to outer query as input.

[kolusu]

satyenderd,

You are scanning 750 mil table and you expect it to run fast?

you can try this sql (untested)

[satyenderd]

Kolusu,

Million thanks once again.

This Forum made my life easy.
_________________
Satya