#DateForumTypeThreadPost
720 Nov 2009 @ 06:53 PSTUDAReplyCopying Table structureHi,I do agree with the above solution.Just create the new primary index on the new table it will not consider the partition from old table and will give the same structure as of old one except part...
630 Sep 2009 @ 08:23 PDTDatabaseReplyLike - WildcardJust create the global temporary table with the same definition as your select columns and indexex:CREATE global temporary table table1( A INTEGER NOT NULL, B INTEGER NOT NULL)on commit preser...
521 Sep 2009 @ 06:18 PDTUDAReplyHelp with Table PartitioningHi Tony, We have designed this type of scenario while buliding the cube in one of our project.Design every instance of the job in different BTEQ script and then call all the BTEQ script in the mast...
420 Sep 2009 @ 04:26 PDTUDAReplyWhat mean TotalCPUTimeHi,TotalCPUTIME in the DBQLOGTBL shows the total time used by the individual AMPprocessor used for that specific query.This amount comes to nearest hundredth of the second.RegardsRajeev T
320 Sep 2009 @ 03:39 PDTToolsReplyData Validation in TeradataHi,fast load creates the two error table and one log table. just checkout the error tables and the status of the report. if the status of the report is other then zero means some of the records are...
220 Sep 2009 @ 03:18 PDTUDAReplyHoe to check which user had deleted dataHi,You can find out by using the system tables which maintain the History. USe three tablesdbc.Dbasedbc.DBQLOGTBLand dbc.DBQLSQLTBL(JUst use the joins AS ) INNER JOIN DBC.DBQLSqlTbl ...
120 Sep 2009 @ 02:56 PDTUDAReplydistinct vs group by, insert vs create asHi,Just check out the Explain plan for the group by and distinct SQL query.You ill see distinct takes more time then Group by caluse.We could see if the table size is medium then it doesn't make su...