#DateForumTypeThreadPost
1024 Jul 2015 @ 03:45 PDTDatabaseReplyALTER PPI - performance impactThanks for the quick response
924 Jul 2015 @ 01:59 PDTDatabaseReplyALTER PPI - performance impactIf the table is under BLOCK LEVEL COMPRESSION(BLC) and there are some rows present in UNKNOWN partition,if we perform ALTER to add partitions will decompress the entire table first and then sc...
816 Jul 2015 @ 03:10 PDTDatabaseReplyALTER PPI - performance impactThanks Dieter for explaining in detail
716 Jul 2015 @ 01:57 PDTDatabaseReplyALTER PPI - performance impactThank You Rglass for the quick update
616 Jul 2015 @ 11:26 PDTDatabaseTopicALTER PPI - performance impactHi,  We are planning to extend our partition range from 2015 to 2025 using ALTER statement. I heard that ALTER is not suggestable for huge tables. My question is for adding partitions to hug...
502 Jul 2015 @ 10:37 PDTDatabaseReplySET table with PPI - optimizer planHi Padhia, Thanks for your response. So Based on PI(ID1: 10) row hash will be generated and it know which amp it has to go,After identifying the Amp according to your answer it will go to particu...
401 Jul 2015 @ 05:25 PDTDatabaseReplySET table with PPI - optimizer planCan somebody please provide the information on this?
301 Jul 2015 @ 02:17 PDTDatabaseTopicSET table with PPI - optimizer planHi, We have a set table with NUPI and is partitioned with date. My question is when we try inserting a new record based on row hash it will perform duplicate checking or it will go to particular p...
211 Jun 2015 @ 04:42 PDTDatabaseTopicFew questions on PPIHi, We are working on extending the PPI ranges in our tables,so i am working on automated script.For this i need to capture following information 1. Can i get partition range  & partitio...
107 Jul 2011 @ 08:57 PDTDatabaseTopicSybase to teradata migrationHi we are planning to migrate from sybase to teradata.Please provide me your valuble guidance/ best practices to perform this activity smoothly Thank You..