Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SI and JI?
- 2 Answers
- 7561 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 a pseudo key? What is its use???
Find 2 highest sal from each dept who have completed 5 year in org
What are the different table types that are supported by teradata?
How a Referential integrity is handled in Teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is the difference between teradata and oracle?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Why do you get spool space errors? How do trouble-shoot them?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Why managing the data is important?
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
if a error occured in FASTLOAD is the fastload job stops?
Teradata 
