What is the difference between SI and JI?
- 2 Answers
- 6668 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 is a clique?
Explain about Skew Factor?
Differentiate primary key and partition key?
How many sessions of MAX is PE capable of handling at a particular time?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
What are differences between teradata and ansi session modes in teradata?
What is meant by a node?
If the table does not have duplicates then which utility you can suggest to load the data ?
What exactly do you know about catching in teradata?
Difference between Teradata V2R5 and Teradata V12 versions?
Explain fastload in teradata?
What is meant by a Channel Driver?
Teradata 
