448 | 30 Apr 2013 @ 12:59 PDT | Database | Reply | Secondary indexes | Also, SI will have some (may be very minor) performance impact as well while loading of data.
|
447 | 29 Apr 2013 @ 06:06 PDT | Database | Reply | Secondary indexes | Its not about view or query .... rather it more relates to the use of the table in question. How the table is going to be accessed? Which columns will be used in joins? What type of queries are to ... |
446 | 25 Apr 2013 @ 10:24 PDT | Database | Reply | Aggregate Operations with Case Specific data | Please share your query for getting the SUM.
Ideally it should return seperate SUM values for Aa and AA.
Also, share the DDL of the table you are doing SUM on, are the columns def... |
445 | 25 Apr 2013 @ 10:14 PDT | Database | Reply | FULL PRIMARY INDEX | Full primary index is .... as Dieter said .... combination of all PI columns.
Every statement .... INSERT, UPDATE or DELETE .... does use PI in one way or another .... but you dont have to... |
444 | 24 Apr 2013 @ 08:44 PDT | Data Modeling | Reply | Converting Rows to Columns | Is it one-time activity? or going to be a continous process?
|
443 | 24 Apr 2013 @ 08:16 PDT | Database | Reply | Secondary indexes | Which ETL tool you are using? Either you can do that in pre-SQL/post-SQL .... or have a combined script from dropping and loading SIs .... or even better option is to use TPT, if possible.
... |
442 | 24 Apr 2013 @ 04:48 PDT | Database | Reply | Division by zero Error | Try:
SELECT AVG(C2) .... if it fails .... open an incident .... if it doesnt .... its not coz of AVG.
|
441 | 24 Apr 2013 @ 04:46 PDT | Database | Reply | Teradata Viewpoint | May be a refreshing issue ....
|
440 | 24 Apr 2013 @ 04:44 PDT | Private Forum |
439 | 24 Apr 2013 @ 04:42 PDT | Private Forum |
438 | 24 Apr 2013 @ 04:40 PDT | Database | Reply | There is another way to remove a volatile table? | What do you mean my removing a VT from SP? As in VT stays created after SP is executed? Or you want to remove the usage of VT from SP?
|
437 | 24 Apr 2013 @ 04:38 PDT | Database | Reply | Check for special character in a string | First you need to define 'special characters' and then you need to use them in LIKE statement.
Example:
SELECT * FROM Table1 WHERE Col1 LIKE ANY ('%/%', '%.%... |
436 | 03 Apr 2013 @ 04:55 PDT | Database | Reply | selecting values from a table where max value is null | Selecting with COALESCE(COL1,CURRENT_DATE)= COALESCE(MAX(COL1),CURRENT_DATE) is best option.
|
435 | 03 Apr 2013 @ 04:43 PDT | Database | Reply | Best way to generate the Sequential numbers : CSUM or IDENTITY columns? | Depends on the questions asked by Dieter.
Based on that, you can use:
IDENTITY
SUM(1) OVER(ROWS UNBOUNDED PRECEDING)
ROW_NUMBER
RANK
....
|
434 | 03 Apr 2013 @ 04:40 PDT | Database | Reply | Stored Procedure Vs Bteq | Few coming in my mind would be ....
BTEQ script:
Simplistic conditional logic
No exception handling
Runs on CLI connection
No concept of parameters
SP:
Complex conditional lo... |
433 | 18 Mar 2013 @ 01:55 PDT | Teradata Applications | Reply | How to optimize the query? The Explain plan is given below. Its showing no more spool space. | Whats the skewnes of underlying tables?
|
432 | 18 Mar 2013 @ 01:50 PDT | Tools | Reply | Need of Collect Statistics | Collection of unnessasary stats does have a downside, but considering your scenario, it shouldnt be an issue.
Moverover, it is always an evolving thing to come up with the best possible st... |
431 | 18 Mar 2013 @ 01:33 PDT | Database | Reply | Can we access a table from SQL UDF in TD 14? | For the correct way o implement that .... again .... What will be the use of this fuction?
|
430 | 18 Mar 2013 @ 01:24 PDT | UDA | Reply | Issue during Conversion of varchar to Timestamp(0) | Sample data would help .... but it seems to be a FORMAT issue.
|
429 | 18 Mar 2013 @ 01:19 PDT | Database | Reply | Data From Vendor Changes | The scenario requires a complete documentation on the format of the file and possible cases to cater for. What is seems is the example of complex structured file containing interrelated data in sep... |
428 | 18 Mar 2013 @ 01:17 PDT | Database | Reply | Stats collection inside SP's | BEGIN and END period data-types are the specific types that Temporal table uses to manage history.
HTH!
|
427 | 17 Mar 2013 @ 11:05 PDT | Database | Reply | GRANT/REVOKE LOGON TO ROLE ? | GRANT/REVOKE LOGON only takes user as an input, not the role. May be you can package the commands in a script for ease of use.
HTH!
|
426 | 11 Mar 2013 @ 02:38 PDT | Database | Reply | Will volatile tables be dropped? | We had an implementation where VTs were being created in dynamic-SQL .... and after some update patch installation same SPs running for months started to fail. On investigation we had to do followi... |
425 | 11 Mar 2013 @ 02:29 PDT | Private Forum |
424 | 11 Mar 2013 @ 02:18 PDT | General | Reply | AMP - Storing the Record | In such a scenario .... one should think before choosing a PI.
It is not a bug of Teradata .... it just doesn't expect a PI to be a column which have only 2 unique values .... imagine ... |