Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SI and JI?
- 2 Answers
- 7556 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 |
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Highlight the differences between Primary Key and Primary Index.
What is meant by a Least Cost Plan?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
which option is used to restart the fastexport script ?
What are the main components of teradata system?
What are the functions performed by bynet?
How to Extract data from multiple legacy systems?
what is use of PI(primary index) AND SI(secondary index)
While creating table my dba has fallback or no fallback in his ddl. What is that?
how many modules are there in telecome domain?how to explain the architecture?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
Teradata 
