Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SI and JI?
- 2 Answers
- 7411 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 the available join types in teradata?
Why teradata is used?
What are the scenarios in which full table scans occurs?
What is node? How many nodes and amps used in your previous project?
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
What is the purpose of upsert command?
How to view every column and the columns contained in indexes in teradata?
Find 2 highest sal from each dept who have completed 5 year in org
The transaction exceeded the maximum number of rowhash locks allowed
Explain vproc in teradata?
Where is teradata rdbms used?
how teradata fetches a row from primary index table?
Teradata 
