Hi,
I have 3 tables
Table A with 100 rows,
Table B with 200 rows,
Table C with 100000 rows.I have a query joining these 3 tables.The Statistics collected on these tables are CURRENT STATISTICS.when I run an Explain on the query,The optimizer redistributes the 100000 rows in Table C(Redistribution consumes huge spool space).
Is it a bug in the Optimizer (or)
Can the optimizer Redistribute the table with less number of rows ?. IF YES,what is tobe done..
Thanks in Advance
Arzoo
I have 3 tables
Table A with 100 rows,
Table B with 200 rows,
Table C with 100000 rows.I have a query joining these 3 tables.The Statistics collected on these tables are CURRENT STATISTICS.when I run an Explain on the query,The optimizer redistributes the 100000 rows in Table C(Redistribution consumes huge spool space).
Is it a bug in the Optimizer (or)
Can the optimizer Redistribute the table with less number of rows ?. IF YES,what is tobe done..
Thanks in Advance
Arzoo