Hi Nazy,
If you don't collect stats for each separate combination, then there will no histogram where the optimizer can see the number of uniques and the interval values. So if y...
Hi,
I'm using the Teradata Studio Version 15.11, version 32 and 64 bits, and I was testing the option to load a volatile table.
My table is very simple:
CREATE VOLATILE TABLE PRUEBA
&...
Hi,
I am trying to install oracle ODBC drivers(PROGRESS_DATADIRECT_ODBC_ORACLE_SOL_SPARC_32.tar) in unix to connect to teradata.When I was trying for 1st time,up to some steps it was correctly...
Thank you Carrie!!
I will go ahead and enable USECOUNT logging on all required permanent databases to make use of it on DR system as well.
Our latest collect job run after we enabled U...
Hi Carrie, Thanks for the explanation...
We sometimes have tables with several multicolumn stats having the same number
of unique values.
In this example:
collect stats column (A,...
Hi Nazy,
The 32 bytes I mentioned is not directly related to MAXVALUELENGTH. MAXVALUELENGTH only applies to the number of characters that are stored in the histogram intervals ...
Wouldn't it be a good idea to add to the tutorial the recepy for setting the dataframe names to the sql resultset column names?
gabnash 2 comments Joined 10/15
16 Oct 2015
cols = []
...
Chandra,
USECOUNT logging is not just used for skipping stats. It is also used for statistics extrapolation. You will not get skipping if USECOUNT logging is off, and the...
Hi, I am trying to Import/Export From/To teradata to Hive using TDCH , But getting below issue with CHAR,VARCHAR and DATE data types not supported in TDCH. As an alternate if we change those dat...
Thanks For the clarification on ROWID......
I have another question. In the original blog you have the explanation below. Could you please expand eon this? I am not...
Thanx Mike for wonderful article, I have completed act-part1 and act-part2, its very informative and well presented.
One silly question how we copy and paste(keyboard shortcut) on aster-queen cons...
Bryan, We are working on getting the statistics display back in the table property form. This is planned for our 16.00 release by end of year.
We have added the Drop back to the Query Development&...
Thank you very much Carrie!!.
We are currently on Release 15.00.04.05 .
We recenlty started stats collection using statsmanager on prod system and started with one database to check the runtimes ...
Hi Francine,
Is there a way to show the currently collected statistics on a table? As far as I can tell the "Collect Summary" option collects summary statistics on a table while the &quo...
Response to the comment from 2 days ago:
Chandra,
The amount of time before skipping will be considered by the optimizer depends. The optimizer usually looks for at least 5 ...
Samir,
Just to be sure that I understand what you mean when you say " In workload distribution, i see that we have only tactical and timeshare defined" Are you ...
Hi Carrie,
We have primary and DR production systems. I am looking to see any options on copy stats from one prod system to another system since same tables exists both and in sync. Can you please...
@Radsubra1 - Here is a simple example that writes the string representation of the row to a file named "result.txt".
with open ('result.txt', 'w') as file:
fo...
Greg, If you have a version of Studio prior to 15.11, the path to your JRE was stored in the TeradataStudio.ini file. The .ini file is located in your install directory. You can change this to refl...
Hi,
I want to connect to teradata and execute a sql from flat file and edirect the output of the file to another sql file.
Iam able to connect to teradata and execute a sql from file but in...
All comment activity
Pages