Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SI and JI?
- 2 Answers
- 7651 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 to view every column and the columns contained in indexes in teradata?
In general, how do you optimze any sql in teradata?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
How to copy teradata scripts from ur remote desktop to server machine?
What is the use of stored procedures in teradata?
What are the 5 phases in a multiload utility?
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
What is the difference between correlated sub queries and inner queries?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
Which is faster fastload or multiload?
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
what happen if a query fail in dispatcher?
Teradata 
