#DateForumTypeThreadPost
5427 Jul 2016 @ 02:44 PDTUDAReplyCollect Stats n Refresh StatsThanks Khurram ok. Will the insert append lag if stats are not collected between Runs?
5326 Jul 2016 @ 10:56 PDTUDAReplyCollect Stats n Refresh StatsI have billions of history data in tables. The jobs do an insert/ append into these tables. Can anybody recommend what is the right time to refresh stats : After each insert/append job? At the en...
5221 Jul 2016 @ 12:28 PDTDatabaseReplyUsing WITH Statement Modifier instead of Temp Tables?How better is the CTE approach than a derived table .??Any recommendations when to use a CTE instead of a derived table. 
5114 Jul 2016 @ 11:47 PDTDatabaseTopicTeradata DBA documentsHi People, I need some Teradata DBA docuemnts that would gear me up for a Teradata DBA Role. Can anybody help me out here. Thansk, Katie
5013 Jul 2016 @ 03:41 PDTDatabaseReplyALTER_PPICan I add a new range partition on a new column in an already created and populated table. 
4913 Jul 2016 @ 03:26 PDTDatabaseReplyextending MLPPI tablesHi ,    I have a table which is partitioned on BUS_DT with a Range_N partition with data (200 million) . I want to include another  RANGE_N partition on CO_ID . Can I do it throug...
4812 Jul 2016 @ 11:02 PDTViewpointReplyMeaning of basic terms I see in ViewpointThanks:)
4712 Jul 2016 @ 06:53 PDTDatabaseReplyTeradata SQL Assistant 15.00 DROP STATISTICS not workingSAME IS NOT working in Teradata 14.10.  How to get the Drop stats work ??Any particular syntax?
4612 Jul 2016 @ 06:37 PDTDatabaseReplyStoring History DAta into tablesOk. Do you think making the partition as 1 month instead of 1 day will help.
4512 Jul 2016 @ 05:56 PDTDatabaseReplyStoring History DAta into tablesIS there any way to quickly uncompress a table?? Alter table remove Compression type of query . Loading and unloading this huge table is freaking me out.
4412 Jul 2016 @ 01:13 PDTViewpointReplyMeaning of basic terms I see in ViewpointThis link doesnot work. Please guys can you share the latest link
4312 Jul 2016 @ 01:09 PDTDatabaseReplyStoring History DAta into tablesYes stats are collected. 
4212 Jul 2016 @ 01:02 PDTDatabaseReplyStoring History DAta into tablesCREATE MULTISET TABLE BA_FCT ,NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL,      CHECKSUM = DEFAULT,      ...
4111 Jul 2016 @ 11:47 PDTDatabaseTopicStoring History DAta into tablesI have a requirement to fit in 441GB of history data into a table which makes my table bulky and difficult to query. Just to explain it is a fact table and stores amount fields etc. I have a partit...
4026 Jun 2016 @ 11:50 PDTDatabaseReplyHigh Skewfactor inspite of even distributionThanks for that piece of information.  Thanks Dieter!
3926 Jun 2016 @ 10:35 PDTDatabaseReplyHigh Skewfactor inspite of even distributionYes Dieter. That solved my problem. How are dbc.tablesize and dbc.tablesizev different?? Will have to find this out. Thanks a lot!
3824 Jun 2016 @ 12:18 PDTDatabaseTopicHigh Skewfactor inspite of even distributionHi All,   Today i came across a weird scenario in Teradata.  One of my tables dbc.table_a  was highly skewed with a skewfactor of 95.77 . I used the below query to check the skewf...
3704 May 2016 @ 12:20 PDTDatabaseTopicHow to access a huge table. Hi All,   I have a huge tbale having 323,456,1898 records. I need to join this table to other tables and also I have some views created on this table. But the Select to this table is really ...
3628 Apr 2016 @ 03:24 PDTUDAReplyHow can I get stats recommendation from Explain?I have 100+ tables in my databse. I want to generate stats on the tables basd on index/partition/join and where clause. Is there any table/view prsent in DBC to give me this list or any genralized ...
3514 Apr 2016 @ 11:24 PDTGeneralReplyCriteria to select Multivalue compressionThanks  Dieter :)
3414 Apr 2016 @ 06:01 PDTGeneralReplyCriteria to select Multivalue compressionI have some repeated values in my table. I should go for compression or partition for quicker access?
3311 Apr 2016 @ 05:43 PDTDatabaseReplyExecution modes in teradataHi Dieter ,    Thanks for the reply. That means We cannot create/replace a UDF in unprotected mode. Right?? Also, Can we change the execution mode of a SQLUDF to unprotected or it is r...
3211 Apr 2016 @ 02:47 PDTDatabaseReplyExecution modes in teradataCan one specify the execution mode of a UDF in the CREATE/REPLACE statement itself? What is the syntax ? Can anybody help?
3111 Apr 2016 @ 01:05 PDTDatabaseTopiccross join hi,   i want to join two tables with no columns common in them but a filter.  SELECT COL1 FROM A JOIN B ON B.COL2 ='H2' I am left joining this table(having 10 milliion records...
3005 Apr 2016 @ 04:14 PDTDatabaseReplyImproving query performancehI, Just wanted to compare  CAST and TO_NUMBER. Which one performs betteR?

Pages