Teradata Material
Pages
(Move to ...)
Home
INFORMATICA
Fall Back,Journals and NODES
FASTLOAD
BTEQ
Teradata SQL
INDEXES
Teradata Architecture
MULTILOAD
CONTUCT US
▼
Showing posts with label
Join Indexes
.
Show all posts
Showing posts with label
Join Indexes
.
Show all posts
Thursday, 26 June 2014
Sparse join index
›
SPARSE join index is being created in Teradata as a result of filtering the rows while joining with the multiple tables. They are a type of...
how To find join indexes that are defined on your table
›
SELECT * FROM dbc . indices WHERE indextype = 'J' AND databasename = 'your_database_name' AND tablenam...
Monday, 10 March 2014
How to find out list of indexes in Teradata?
›
How to find out list of indexes in Teradata? IndexType Description P Nonpartitioned Primary Q Partitioned Primary S ...
How does indexing improve query performance?
›
Answers: Indexing is a way to physically reorganize the records to enable some frequently used queries to run faster. The index can ...
›
Home
View web version