#DateForumTypeThreadPost
904 Sep 2016 @ 11:39 PDTDatabaseReplyMerge into operationThanks Saeed and Carlos for the clarification. I was comparing an insert against a merge into and it appeared that while CPUTime for Merge(with only when not macthed clause) was less, the...
808 Aug 2016 @ 11:01 PDTGeneralReplyImprove performance on an analytical query , mulitple columns using same set of partitions We do an all-AMPs STAT FUNCTION step from Spool 2 (Last Use) by      way of an all-rows scan into Spool 6 (Last Use), which is assumed      to be redistr...
708 Aug 2016 @ 03:08 PDTGeneralTopicImprove performance on an analytical query , mulitple columns using same set of partitions Hi, I have a large query where there are two window sets, one over year and another over quarter. I think that since teh parttion by and order by clause is same for 1 set of column and anoth...
624 Jul 2016 @ 11:05 PDTDatabaseReplyConsequential inserts into large fact table performing very slow inside stored ProcedureThanks Dieter. but the target table is already populated even in the 1 st insert , its not an empty table. Still I can see that the 1st insert is actually better. If I pull all the inserts into 1 t...
524 Jul 2016 @ 10:04 PDTDatabaseReplyMerge into operationThanks Khurram, but as I understand that apart from the NUPI for the join  condition, need to specify a unique set of columns(like a Primary key) for merge operation. In my case there is no se...
422 Jul 2016 @ 04:18 PDTDatabaseTopicMerge into operationI am rewriting an insert statement which was taking lot of time, as a Merge statement. The target table is Multiset also it has a composite NUPI. the source may have non unique rows. Is it at all p...
321 Jul 2016 @ 10:28 PDTDatabaseTopicConsequential inserts into large fact table performing very slow inside stored Procedure  Run_Id Check_Point Check_Point_Desc Records_Processed time_elapsed 16 201,607,122,102 1 Delete From    Xyz 110,013,266   0:...
208 Feb 2011 @ 11:25 PSTViewpointTopicSMS alerts through View PointHi, My customer mentions that they cannot use View Point for sending SMS, only the feature of email and SNMP is available. Is there a workaround to send sms from ViewPoint? Thanks!
103 Feb 2011 @ 05:47 PSTDatabaseTopicPerformance tuning by avoiding distinct hi, I have a complex query with multiple columns in the group by clause. Also, in the select list there is a count(distinct), because of which the entire group by aggregation is performed twic...