#DateForumTypeThreadPost
720 Mar 2013 @ 08:03 PDTDatabaseReplyPerformance considerations during taking back up--Hi Dieter , Both are having same Structures but they are created at different databases, i mean, one at LIVE and other at BACKUP Db. does different DB's making the usage of spool in INSERT Se...
620 Mar 2013 @ 07:06 PDTDatabaseReplyPerformance considerations during taking back up--Thanks Dieter for the Response.. Actaully the thing is ,we have PPI defined on A so when we do the  INSERT SELECT on the empty A_bkp table then in this case  optimizer is using the spool...
519 Mar 2013 @ 07:15 PDTDatabaseTopicPerformance considerations during taking back up--Hi Experts, Need Your suggestions among the 2 possible scenerio through which we can take the backupof a  Huge table at production. Scenerio 1- Create table a_bkp as A with Data and Stats; ...
414 Mar 2013 @ 10:18 PDTDatabaseReplyPerformance tuningHi , Just check the  Explain plan of both the Queries.. Will get to know the differences..check the timings and final spool size in the Explain..  I think both would be same as its a inn...
309 Mar 2013 @ 05:15 PSTDatabaseReplyRegarding the limitation of Derived table using With clause-Hi all, I got my answer... Good news is that teradata 14 is providing the flexibility of using the 2 WITH clauses in SQL.   Cheers ! Nishant
209 Mar 2013 @ 05:00 PSTDatabaseReplyTimestamp format not working to get the two digit yearHi SF Rafi, I belive you can get the similar Output using the Recursive Queries..   thanks! Nishant Bhardwaj
120 Mar 2012 @ 09:42 PDTDatabaseTopicRegarding the limitation of Derived table using With clause- hi teradata experts, In my Project,(in most of the teradata queries ) i am using one Derived table (using With clause)  which is attached to Main query, which is very good in terms ...

Pages