Archives of the TeradataForum

Message Posted: Fri, 27 May 2011 @ 09:42:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, May 27, 2011 03:23 -->

Hi,

I have a query which is as below

     Sel
        Col1,col2,col3,col4,col5
     From table1 where col1 > 100
     UNION ALL
     Sel
        Col1,col2,col3,col4,col5
     From table1 where col2 is not null
     UNION ALL
     Sel
        Col1,col2,col3,col4,col5
     From table1 where col5 =  X

Is there any way to rewrite the query. The query does repeated scans of the same table and there is no correlation between the multiple WHERE conditions.

Is there any way spool the full table scan and from the spool try applying the filters to get the required resultsets into separate spools and finally join them.

Let me know

thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>