#DateForumTypeThreadPost
525 Sep 2015 @ 12:31 PDTDatabaseReplyCollect Stats - How Performance gets improved?Another aspect of collect stats - combination stats. A  lot of times there are a lot of combination stats suggested by the optimizer . The ones that involve where clause ( and frequently so ) ...
424 Sep 2015 @ 10:59 PDTDatabaseReplyCollect Stats - How Performance gets improved?Thank You.That makes a LOT of sense.  The obvious was staring at my face , yet I could'nt  connect the dots. I had another post over . No hits on it so far. When you have a min Todd....
317 Sep 2015 @ 11:45 PDTDatabaseReplyHow to optimize queries that have aggregation involving multiple fact tablesTuning Gurus .. SQL Pundits... Dieter & other  Teradata Masters...where are you all ( I heard from my other friends ... you are pretty active). Well thanks in advance for this one .
216 Sep 2015 @ 02:27 PDTDatabaseTopicHow to optimize queries that have aggregation involving multiple fact tablesThere is  "poetic query" that takes forever to run Kind of looks like this sel col1.tb1, col2,tb1, (case <condition involving tb1 and tb2>) as "Dcol1", Sum ( co...
116 Sep 2015 @ 09:18 PDTDatabaseReplyCollect Stats - How Performance gets improved?I have a column whose access count rank is like # 9 amongst 150 column in a table ( it is widely accessed ) but the distinct value for it is just one  ( 'y'). Does it help collecting ...