tag:blogger.com,1999:blog-1556110042987012571.post8042791170010886524..comments2022-12-04T06:09:53.389-05:00Comments on Teradata Tips: Performance tuning #1Meena Athmanathanhttp://www.blogger.com/profile/15342471362722574934noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-1556110042987012571.post-14333015959105330492012-09-22T00:08:21.673-04:002012-09-22T00:08:21.673-04:00What are the Key- words need to understand in expl...What are the Key- words need to understand in explain plan and how it helps while taking decisions to improve the performance ? Plz help me with some detailed scenarios. Anonymoushttps://www.blogger.com/profile/03637262630235895956noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-71169745683548195662011-11-11T08:44:10.512-05:002011-11-11T08:44:10.512-05:00Hi Meena ,My side am Santhosh am working as a tera...Hi Meena ,My side am Santhosh am working as a teradata Developer from last 3 years onwards . Nice blog and good respose also. Keep rocking :).<br />From myside i will do my best . My mail id msanthu1985@gmail.com<br /><br />Have a nice day.SanthuMithintihttps://www.blogger.com/profile/05536138194103822646noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-45241423368111215302011-11-08T07:11:16.351-05:002011-11-08T07:11:16.351-05:00Hi meena this is prala....i have interest to learn...Hi meena this is prala....i have interest to learn TERADATA DATABASE..send any document regarding TERADATA to my id:mandiprala@gmail.com<br />Thanks&Regards<br />Prala.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-77603728894821013212011-10-13T07:03:49.918-04:002011-10-13T07:03:49.918-04:00hi madam dis is ram from india...
i have some dou...hi madam dis is ram from india...<br /> i have some doubts in teradata performance tuning and indexes?...<br />when ever u r free plz reply me...ramhttps://www.blogger.com/profile/07155319719363783096noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-63550997291559077172011-10-12T07:37:03.667-04:002011-10-12T07:37:03.667-04:00Hi Meena..
In teradata how the data flow ...Hi Meena..<br /> In teradata how the data flow from source to target?would u plzzz send this answer to my mail mahaboobteradata@gmail.commahaboobhttps://www.blogger.com/profile/08422406401615337494noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-83387415994877432682011-06-30T13:47:04.444-04:002011-06-30T13:47:04.444-04:00@Himanshu...In Multiload you cannot use USI on loa...@Himanshu...In Multiload you cannot use USI on loading table, as mload has to load data parallely and independently in each amp that is what it is for to load the data as fast as possible,so if we use USI index subtable might be in other amp as compared to your data row that will need a communication between the two amps and it doesn't support that, you can use NUSI in mload. Rather u can drop the secondary indexes before loading and can recreate them after the load is completed.<br /><br />Cheers!teraheadhttps://www.blogger.com/profile/02787391194613692980noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-10782186191529426422011-06-27T13:44:32.025-04:002011-06-27T13:44:32.025-04:00Great article Meena.....One question.....In multil...Great article Meena.....One question.....In multiload....we have some limitation for the target table...... one of the limitation states...you cannot use USI in the target table. Why it is so?Himanshuhttps://www.blogger.com/profile/09129227640775623205noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-13772710178266510552011-05-19T01:51:19.928-04:002011-05-19T01:51:19.928-04:00i ran one update query i need to update 1000 in be...i ran one update query i need to update 1000 in between update query i can stop where i can see the upadate records, where is store records plz tell me i have face thes problemsivaprasadhttps://www.blogger.com/profile/17565510177559114644noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-15927224832366362492011-05-19T01:49:08.763-04:002011-05-19T01:49:08.763-04:00hai mam this is siva i am new to teradata what is ...hai mam this is siva i am new to teradata what is difference between PE and optimizer plz send to my mail sivaprasad.kaja@gmail.comsivaprasadhttps://www.blogger.com/profile/17565510177559114644noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-46704326577293072022011-03-15T01:28:56.430-04:002011-03-15T01:28:56.430-04:00WHAT ARE THE Issues ARE YOU FACING while loading ...WHAT ARE THE Issues ARE YOU FACING while loading the data in MLOAD?Teradatahttps://www.blogger.com/profile/14709341008670616526noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-40867419990884204342011-03-01T05:44:20.605-05:002011-03-01T05:44:20.605-05:00Hi meena this is gowri...working as a oracle core ...Hi meena this is gowri...working as a oracle core DBA..i have interest to learn TERADATA DATABASE..send any document regarding TERADATA to my id:gowri.nageswararao@gmail.com<br />Thanks&Regards<br />GOwri.oracle DBAhttps://www.blogger.com/profile/00774901291511125079noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-41832774501461368052011-02-16T02:18:58.219-05:002011-02-16T02:18:58.219-05:00Great work Meena.....appreciatingGreat work Meena.....appreciatingBhanwar Pratap Singhhttps://www.blogger.com/profile/05857676307791656062noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-29933019054842712632011-02-03T01:03:14.003-05:002011-02-03T01:03:14.003-05:00Sry for asking this question,
Do you train, novice...Sry for asking this question,<br />Do you train, novice ppl in teradata, i have Oracle Db background, looking for ramp up in training. if so, can you kindly email to one.sbabu gmail.comsharathttps://www.blogger.com/profile/10581692817921704475noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-57644502474955846932010-12-22T20:07:23.073-05:002010-12-22T20:07:23.073-05:00Thank you all for the interest! I prefer not to po...Thank you all for the interest! I prefer not to post personal contact details in my blog to avoid spam. Kindly post a comment, I will try to respond to your request as early as possible.<br />Apologies if I could not respond to you quickly, I might have forgotten myself @ work :)Meena Athmanathanhttps://www.blogger.com/profile/15342471362722574934noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-70981277702481790822010-12-07T23:18:50.795-05:002010-12-07T23:18:50.795-05:00Hi Meena, Please provide your mail idHi Meena, Please provide your mail idDebasishttps://www.blogger.com/profile/12645468955030507000noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-50955157838145836682010-12-02T08:28:38.750-05:002010-12-02T08:28:38.750-05:00i hav so many doubt in teradata(this is my no 9985...i hav so many doubt in teradata(this is my no 9985261714)plese feel free can u call me. this is thirupathithirupathihttps://www.blogger.com/profile/11891963824361788835noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-53643494018548998332010-07-16T10:09:42.099-04:002010-07-16T10:09:42.099-04:00Hello Meena,
Can you please provide example Proce...Hello Meena,<br /><br />Can you please provide example Procedure where we can generate a surrogate key based on 4 input parameters and out parameter being the surrogate key of the Procedure.Unknownhttps://www.blogger.com/profile/11414066292909639137noreply@blogger.com