#DateForumTypeThreadPost
6629 Jan 2012 @ 06:54 PSTUDAReplyCollect stats in ETL In case you do not deal with mload scripts but call mload via the api I would expect that datastage is offering native SQL api as well where you can call collect stats commands. I don't ...
6528 Jan 2012 @ 11:34 PSTDatabaseReplyNew Member - First Post http://www.teradataforum.com/ independent and has a big archive
6427 Jan 2012 @ 04:45 PSTGeneralReplySpool space taken by Query I think you will not get good estimates as it depends from many things like compression, number of vproc, number of rows, the actual plan etc. explain gives you estimates on the estimated ro...
6325 Jan 2012 @ 12:13 PSTToolsReplyusing errorcode   You can the the bteq manual! The label can be always the same as BTEQ will only move forward in this script. So you can paste the four line above after each collect stats wit...
6223 Jan 2012 @ 11:50 PSTDatabaseReplyQuery optimization Hi, it looks like your statement is much more complicated as just a two table join. Can you share all ddls? Run a show in front of your SQL and you will get all DDLs related to this ...
6123 Jan 2012 @ 11:45 PSTToolsReplyusing errorcode There is also an option in sql assist to proceed in case of an error - but any kind of error... Tools -> Options -> Query - un tick on Stop query execution... but bteq is clearly t...
6023 Jan 2012 @ 01:42 PSTDatabaseReplyCheck row is Numeric or not Hi, we shared our thought and at least I would be interessted how you solved your problem!
5920 Jan 2012 @ 01:25 PSTGeneralReplydirty read record   Lets assume you have a big table A - a full table scan needs 10 min with where condition colX = 1 .   User A starts a select count(*) with condition colX = 1 with lock fo...
5820 Jan 2012 @ 12:16 PSTDatabaseReplyPerformance problem gain performance for what? Read 1.6 TB faster? buy more HW. Getting faster responce for    select top 10* from Employee.empdetails where emp_ind=1;? Create a single tab...
5720 Jan 2012 @ 12:10 PSTPrivate Forum
5619 Jan 2012 @ 07:36 PSTDatabaseReplyPerformance problem so what do you expect if you query a 2TB table with an condition which returns 80% - 1.6TB - of the rows? As mentioned  select top 10* from Employee.empdetails where emp_ind=1; ...
5519 Jan 2012 @ 06:40 PSTDatabaseReplyPerformance problem what is the demographic (row counts) of the two values 0 and 1? And what do you want to achive?  
5419 Jan 2012 @ 04:54 PSTGeneralReplypermanent space availability,space,permanent space Again, not sure that I understand what you asking for. All DDLs need some minor space to be stored in the DB. So if you do not have any perm space assigned to a DB you can not store any VIEW...
5319 Jan 2012 @ 04:50 PSTGeneralReplyRegeneration of report You might start to read the TD documentation. BTEQ is a utility to exec SQL, others are available. Optimizer, PE and AMPs are part of the DB architecture and are involved by executing a ...
5219 Jan 2012 @ 04:48 PSTGeneralReplydirty read record I don't understand the question. Access lock allows to read a table where an write lock is placed. The table is stored on disk or might be available in cache - where you have no controll...
5119 Jan 2012 @ 03:21 PSTDatabaseReplyPerformance problem Hi, don't compare apples with pears. Top 10 will give you the first 10 rows of the final result set.  Select top 10 * from Employee.empdetails  has no contrain...
5019 Jan 2012 @ 12:58 PSTDatabaseReplyBest way to update single column in a large table. delete and insert will result in journal where insert/select into an empty table will not.  As you are going to update 75% of the table I would expect that insert / select into empty ta...
4918 Jan 2012 @ 11:31 PSTPrivate Forum
4818 Jan 2012 @ 11:30 PSTPrivate Forum
4718 Jan 2012 @ 10:25 PSTToolsReplyFormatting BUG in BTEQ EXPORT of a SHOW Procedure what is your issue with the blank? it is still valid and executable try select * from sys_calendar     .     calendar where date = calendar_Da...
4618 Jan 2012 @ 08:33 PSTDatabaseReplyBest way to update single column in a large table. P.S. Did you drop the INDEX SI_124 ( VAL_STATUS_CD ) before the update? P.S.S. -not advisable for a long term solution but can give you some time for the implementation. Did you cons...
4518 Jan 2012 @ 08:28 PSTDatabaseReplyBest way to update single column in a large table. and afterwards rename tables and drop old table etc...
4418 Jan 2012 @ 08:27 PSTDatabaseReplyBest way to update single column in a large table. Do you have enough space for a copy of the table? So insert select into an empty table having the same table definition and the Select is applying the update logic via a case statement...
4318 Jan 2012 @ 02:34 PSTDatabaseReplyDifference of rows in SELECT COUNT(*) and SELECT * Hi, lock row for access has the benefit that the DB detects which need to be done. If you access only one PI value it will place a row lock for access. If you access the whole table ...
4216 Jan 2012 @ 11:54 PSTDatabaseReplyHow to cleanse non numeric characters from a field? To be honest - you will not find an elegant solution for this using plain SQL. Either doing the cleansing outside with an ETL tool or using and specific UDF would be good but it seems it is ...

Pages