Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SI and JI?
- 2 Answers
- 7465 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 meant by a Channel Driver?
What is a pseudo key? What is its use???
Can you fastexport a field, which is primary key by putting equality on that key?
Why MLOAD needs Work Tables?
how teradata fetches a row from primary index table?
What is meant by a Clique?
What do you mean by ttu in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com
What are the string manipulation operators and functions associated with teradata?
What is the difference between union and union all in teradata?
what is the default character set in teradata,,?
in teradata level primary in table level allows duplicates why?
Teradata 
