Answer Posted / veena
SI is like pointer to the base rows where as JI stores actual rows
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is difference between user and database in teradata?
Where is teradata rdbms used?
What is the meaning of Caching in Teradata?
Explain the term 'row' related to relational database management system?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
why use references rather than pointers in the public api, particularly for arguments which are modified?
Explain and compare pros and cons of snow flake schemas?
Explain how spool space is used.
Can you fastexport a field, which is primary key by putting equality on that key?
What are the different softwares used with their functions in teradata?
In general, how do you optimze any sql in teradata?
What type of indexing mechanism do we need to use for a typical data warehouse?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
How many types of joins are there in teradata?