Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SI and JI?
- 2 Answers
- 7517 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / veena
SI is like pointer to the base rows where as JI stores actual rows
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sivareddy
si it avoids the full table scan nd it gives the fast reterival of the data and use the extra perm space where as join index it holds the one or more then tables data nd stored in perm space.at the time of joined two table it will take data from join index.and also it will use aggregate operations,anylatical operations.
| Is This Answer Correct ? | 1 Yes | 0 No |
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
How is Teradata in current market?
What happens when a node suffers a downfall?
What is the function of parser component in teradata?
What is a dimension table?
What is a clique?
What are normalization, first normal form, second normal form and third normal form?
What are the 5 phases in a multiload utility?
What interface is used to connect to windows based applications?
What is a node in teradata?
Explain the term 'foreign key' related to relational database management system?
can we join volatile table with general table an global temporary table with general table ?
Teradata 
