#DateForumTypeThreadPost
1629 Dec 2013 @ 06:00 PSTDatabaseTopicRun time explain plan for a queryIam using Teradata 14.x.  I come from Oracle background. In Oracle, there are data dictionay views to look at explain plan" when query was actually  exceuted which can be diff...
1523 Dec 2013 @ 06:22 PSTDatabaseReplycreate set table vs. create multiset tableSomething new I learnt.  
1422 Dec 2013 @ 10:56 PSTDatabaseTopiccreate set table vs. create multiset table  If my table will always have a  unique primary or secondary  index, does it still Make sense to use create set table statement to create tables. I come from Oracle and SQL Serve...
1321 Dec 2013 @ 03:15 PSTDatabaseReplyDoes one need unicode compression in Tredata 14.0http://goldenorbit.wordpress.com/2013/03/09/latin-utf8-and-utf16-with-teradata/     Unicode strings are stored as UTF16 on disk anyway. Yes, space is wasted; that’s why th...
1220 Dec 2013 @ 02:23 PSTDatabaseTopicDoes one need unicode compression in Tredata 14.0Iknow i Teradata 13.x, followng syntaxt is provided to implement compression for unicode CREATE TABLE Customer (Customer_Account_Number INTEGER, Customer_Name VARCHAR(50), Customer_A...
1119 Dec 2013 @ 08:16 PSTDatabaseReplyHow to cast a clob to varcharI figured out it myself. select cast(substr(mytext, 1, 500) AS VARCHAR(500)) as mytext2
1019 Dec 2013 @ 03:19 PSTDatabaseTopicHow to cast a clob to varcharI have  a clob cloumn called mytext select substr(mytext, 1, 500) from my table Still substr is returned as clob because it is taking me to store this reuslt in some file in Tredata Stu...
918 Dec 2013 @ 06:53 PSTDatabaseTopicQuestion on Stored procedure  This is my first  attempt to write a  stored procedure in Teradata. I am getting an authorization error: The user does not have CREATE PROCEDURE access to database pmehrotr ...
815 Dec 2013 @ 06:31 PSTDatabaseTopicWhy teradata does not give access to statistics views in dbc by default?      I come from Oracle backgrond. In Oracle if you have access to your database, you can look in user_tables and user_indexes to see last analyzed to find when statistics was ru...
715 Dec 2013 @ 06:12 PSTDatabaseTopicWhy explain plan is so off  I am new to Teradata. I am doing an explain on a  sql statement select * from myview where myview is a join of 10 tables.   I see in last few line of explain " &nbs...
610 Dec 2013 @ 10:33 PSTDatabaseReplyWhy I do not see all the databases in Teradata Studiofgrimmer:   That was it. Thank  you so much. I can now see all the databases.   Prem
509 Dec 2013 @ 02:29 PSTDatabaseReplyWhy I do not see all the databases in Teradata StudioI do not have access to DBC. There is something in TREDATA Studio which is different from SQL Assist. When one does LDAP authentication in Terdata Studio, it does not show all the databases I have ...
405 Dec 2013 @ 04:47 PSTDatabaseReplyWhy I do not see all the databases in Teradata StudioThanks a lot. What do you mean connecting using DBC. Do you mean do not use LDAP.
304 Dec 2013 @ 10:09 PSTDatabaseReplyWhy I do not see all the databases in Teradata StudioMy Authentication is LDAP and I did not sepcify any database (.e. database is BLANK).
204 Dec 2013 @ 04:40 PSTDatabaseReplyWhy I do not see all the databases in Teradata StudioThanks. but I do not see poperties like default schema... I am on Tredata Studio 14.0.4...   Since I am on windows platform, I also have Tredata SQL Assist.. There also I do not see all sche...
103 Dec 2013 @ 03:07 PSTDatabaseTopicWhy I do not see all the databases in Teradata StudioI am using Teradata Studio 14.0 on Windows 7.  In database source explorer I do not see all the databases which I have access to, why? In SQL Editor  I can netr query like: select * from...