#DateForumTypeThreadPost
716 Apr 2013 @ 11:59 PDTDatabaseReplyDATE Index in TeradataI saw this DATE index in sybase. In teradata should we use the PPI ? Please clarify.
616 Apr 2013 @ 12:39 PDTDatabaseTopicDATE Index in TeradataHi , I create a volatile table as mentioned below CREATE MULTISET VOLATILE TABLE temp_table (  col1   BIGINT  ,  start_dt  DATE   )ON ...
514 Apr 2013 @ 10:26 PDTDatabaseTopicTOP vs QUALIFY RANK to fetch recordsWhich is the best option in means of performance ? selecting rows using top clause without any order by clause (or) selecting rows using qualify rank() over() =1 ?  
403 Apr 2013 @ 09:42 PDTDatabaseReplyselecting values from a table where max value is nullSo, is the volatile table option compartively less effective than the COALESCE Option in the filter ?  
331 Mar 2013 @ 08:03 PDTDatabaseTopicselecting values from a table where max value is nullI have to select rows from the table where col1=max(col1). Here if the max(col1) is null, i dont get results because NULL cannot be compared as far as i know. Temporarily i have used COALESCE(COL...
220 Feb 2013 @ 08:49 PSTDatabaseReplyCursors in stored proceduresDo we have any other option apart from using cursors to return resultset from a teradata stored procedure?  
119 Feb 2013 @ 03:25 PSTDatabaseTopicCursors in stored proceduresHi,   I have to create a stored procedure which returns resultset. Common answer to this was the usage of cursor inside the stored proc. I have few questions on using cursors ...