Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SI and JI?
- 2 Answers
- 7659 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 do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
Explain fastload in teradata?
Describe the set operators in teradata.
What is teradata and why it is used?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
What do you mean by fastexport in teradata?
How to Extract data from multiple legacy systems?
How to copy teradata scripts from ur remote desktop to server machine?
What is the difference between global temporary tables and volatile temporary tables?
What is Difference b/w PI & PPI?how to implement PPI?
Highlight a few of the important components of Teradata?
Teradata 
