Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between SI and JI?
- 2 Answers
- 7551 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 |
How many codd's rules are satisfied by teradata database?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
0 Answers Infosys, Wells Fargo,
What is the use of upsert command in teradata?
What is the function of parser component in teradata?
what is DYNAMIC SQL in TD?
What is the use of stored procedures in teradata?
What do you mean by teradata intellicloud?
Highlight a few of the advantages that ETL tools have over Teradata.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain fastload in teradata?
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
The transaction exceeded the maximum number of rowhash locks allowed
Teradata 
