# | Date | Forum | Type | Thread | Post |
9 | 04 Sep 2016 @ 11:39 PDT | Database | Reply | Merge into operation | Thanks 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... |
8 | 08 Aug 2016 @ 11:01 PDT | General | Reply | Improve 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... |
7 | 08 Aug 2016 @ 03:08 PDT | General | Topic | Improve 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... |
6 | 24 Jul 2016 @ 11:05 PDT | Database | Reply | Consequential inserts into large fact table performing very slow inside stored Procedure | Thanks 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... |
5 | 24 Jul 2016 @ 10:04 PDT | Database | Reply | Merge into operation | Thanks 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... |
4 | 22 Jul 2016 @ 04:18 PDT | Database | Topic | Merge into operation | I 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... |
3 | 21 Jul 2016 @ 10:28 PDT | Database | Topic | Consequential 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:... |
2 | 08 Feb 2011 @ 11:25 PST | Viewpoint | Topic | SMS alerts through View Point | Hi,
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!
|
1 | 03 Feb 2011 @ 05:47 PST | Database | Topic | Performance 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... |
|
|