928 Dec 2014 @ 08:31 PSTDatabaseReplyBTEQ Command to execute sqls only to generate explain planI believe using a script we can append the explain to every sql and then we can run the bteq calling the newly built file as  Raja Sir said
828 Dec 2014 @ 08:28 PSTDatabaseReplyQUALIFY ... OVER (PARTITION BY ...) phraseQualify basically tells the database to apply the analytical function (e.g: sum(),max(),min(),avg(),row_number(),rank() etc..) over the number of rows specified insider the over() clause.
728 Dec 2014 @ 06:18 PSTTeradata ApplicationsReplyQuestions on Inside AMPHi can someone please throw some light on the above questions please. I am also having the same query.
627 Dec 2014 @ 09:09 PSTDatabaseTopicJoin Index usageDo we practically ever use join indexes? Can you please provide a real life scenario when join index would be beneficial in a production environment?
527 Dec 2014 @ 08:38 PSTDatabaseReplyGTT vs VTI thought for volatile tables there are no data dictionary involvement at all. So why is there a need for calls to DBC tables? Can you please explain?
427 Dec 2014 @ 09:53 PSTDatabaseTopicGTT vs VTWhen do we choose a global temporary table over volatile table or vise-versa?
330 Nov 2014 @ 08:09 PSTDatabaseReplyJOIN INDEXES WITH PRIMARY INDEXThere is an option to have a join index with UPI :)
230 Nov 2014 @ 07:38 PSTDatabaseReplyQUERY OPTIMIZATIONThank you so much Dieter, Ulrich and VandeBerg.
130 Nov 2014 @ 05:32 PSTDatabaseTopicQUERY OPTIMIZATIONI faced this scenario in an interview. Suppose there are 2 large tables say CUSTOMERS AND CUSTOMER_SESSIONS. The CUSTOMERS table holds the CUST_ID and CUST_NAME say for a website such as facebook/a...