2013-12-21 03:26
The data distribution of table among AMPs is called Skew Factor.Generally for NUPI, we get duplicate values, so the more dulicate values you get the more the data will have the same row hash… Read More
Blog Directory > Blogging Blogs > Guides Blogs > Teradata SQL Reference guides Blog >
2013-07-19 09:03
TPump is similar to MLoad, TPump edits Teradata tables by processing insert, updates, and deletes.TPump performs updates on the Teradata Database in a synchronous manner. Changes are sent in… Read More
2013-07-08 07:44
TPump is a data loading utility that helps you maintain (update, delete, insert, and atomic upsert) the data in your Teradata Database. Used to keep the target table updated continuously … Read More
2013-07-06 09:43
A procedure or function is a schema object that consists of a set of SQL statements and other PL/SQL constructs, grouped together, stored in the database, and executed as a unit to solve a s… Read More
2013-07-04 09:22
Data modeling is a method used to define and analyze data requirements needed to support the business processes of an organization. The data requirements are recorded as a conceptual data mo… Read More
2013-07-01 09:48
Oracle's two major index types are Bitmap indexes and B-Tree indexes. B-Tree indexes are the regular type that OLTP systems make much use of, and bitmap indexes are a highly compressed index… Read More
2013-07-01 09:35
Simplify access to objects by creating a synonym (another name for an object). With synonyms, you can:• Ease referring to a table owned by another user• Shorten lengthy object name… Read More
2012-12-24 16:56
TPUMP is a flexible multi-session load utility. The only characteristic of TPUMP that limits its use is its transaction oriented nature. If the situation allows execution of Fast… Read More
2012-12-22 10:41
The syntax for the CREATE TABLE statement has been changed to permit user data tables to be created without a primary index. Such tables are referred to as NoPI (No Primary Index) tables.Thi… Read More
2012-12-12 15:55
It is possible to create functions which operate on large object data types. The following library functions exists to provide the ability use LOB's as function input or output:• FNC_Ge… Read More
2012-11-27 17:05
1. Partition Primary Index(PPI) occupies extra two bytes for storing partition number.2. Partition Primary index cannot be created on volatile and Global Temporary tables and compressed join… Read More
2012-11-27 17:03
· Range queries eliminates the use of Full Table Scan.· PPI is an alternate to secondary index, it provides an excellent solution compared to secondary indexes. PPI can make mo… Read More
2012-11-27 06:48
Suppose if you have a table called employee having column salary declared as decimal(35,0).Query: Select salary from employee;The above query works fine in SQL Assistant. But if you try to r… Read More
2012-11-26 16:56
When developing queries, always perform “An explain” on the query before you run it. Explains can give a lot of information the way optimizer will execute a query. To… Read More
2012-11-26 16:55
Derived tables can be a powerful technique to produce efficient queries, but they can also cause major performance problems when used in inappropriate situations.Here are some guidelines f… Read More
2012-11-06 18:02
Significance of OLAP Features:Execution Time of the Query is minimized to a significant level after using OLAP features.Less complex query can be formulated by OLAP functions… Read More
2012-10-17 18:09
The following are the date and time functions in Teradata.DATE or CURRENT_DATE - Both displays current date.ADD_MONTHS(date,3) - Add 3 months to the current date.ADD_MONTHS(date, -2)… Read More
2012-10-13 14:00
Be careful while choosing the primary index because it affects the data storage and performance.The following are the important tips while choosing the primary index.1. Data Distribution.You… Read More
2012-07-04 19:13
If its arguments are equal,NULLIF returns NULL , else it returns its first argument, scalar_expression_1.For the following full CASE expression NULLIF is a shorthand expression :CASE W… Read More
2012-06-23 20:23
1.Suppose if collect stats is created on table , we can delete the data of the table by using delete statement those collect stats also be deleted or not?Ans: No collect stats will not… Read More
2012-06-22 08:27
The MERGE INTO statement 'merges' a source row into a target table based on whether any rows in the target table match a specified condition with the source row.MERGE INTO replicates the fun… Read More
2012-06-21 12:05
When the primary index value of a row is input to the hashing algorithm, then the output is called the “row hash”. Row hash is the logical storage address of the row, and identif… Read More
2012-06-21 11:33
The POSITION function Returns the actual position of the character which occurs first. POSITION function is ANSI standard.Teradata has an equivalent function called INDEX.Both the POSITION a… Read More
2012-05-26 18:07
Create Function: compile, link and add a new function to a database a function.Create Function privilege- enables user to Create a function.This privilege is not granted automatically a… Read More
2012-05-15 11:36
A recursive trigger contains a triggered action which causes the triggering action to reoccur. For example, assume a row trigger is defined with a triggering action that inserts a row into a… Read More
Subscribe to Teradata Sql Reference
Get updates delivered right to your inbox!