Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SI and JI?
- 2 Answers
- 7415 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 |
What are different table types used in teradata?
What is TPD?
Explain teradata architecture?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What are aggregate tables? How do you design them using teradata?
How do you Generate Sequence in Teradata?
Explain and compare pros and cons of start schemas?
In Teradata, what is the significance of UPSERT command?
What is the difference between fastload and multiload?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is the diffrence between Multiload & Fastload interms of Performance?
Teradata 
