Joined: 23 Aug 2006
Following Db2 tables with records...
Table A has 1,00,000 records,
Table B has 1,00,000 records,
Table C has 1,00,000 records,
According to my Condition for Table A will fetch only 100 records after processing ,
method 1: lot of scanning ....
join Table A, Table B and Table C
Get the result .
method 2 : (Is possible)
Cursor A :
table A with Some Condition
result: 1000 recors.
join Cursor A with Table B, Table C
to reduce the scanning of all records from Table A , Only 1000 records will be scanned.
It is possible , if it how can we do this?