Archives of the TeradataForum
Message Posted: Wed, 27 Aug 2008 @ 12:37:30 GMT
Please give your suggestion on the partition concept without using partition defined column how do we run sql in the optimized way?
Following is the query
We have partition on the TAB1.<col2> column when we use the hard coded date values in the IN clause query run with in 30 sec but needed above mentioned subquery that time taking long time more than 10 min. What is other best way to write this sql?
Thanks in advance
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|