What is the difference between SI and JI?
- 2 Answers
- 6380 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 object level locking ? where do appear this type of locking ?
Explain the most common data types used in teradata?
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
Which Teradata concept allows more than one model generation?
How do you determine the number of sessions?
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
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
which utitility can use for loading the data from non-teradata to teradata ?
Highlight the need for Performance Tuning.
what is the difference between primary index and secondary index?.
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is the difference between teradata and basic rdbms?
Teradata 
