Interested to Buy Any Domain ? << Click Here >> for more details...
difference between For each and for all
- 2 Answers
- 9330 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manshul goel
FOR EACH is considered as a "group by" in the SQL generated
while when we apply FOR ALL it generates SUMMARY on the
basis of the element
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shishir
For each will process the statements for each row of the
bulk collect ,whereas for all will process all the records
in a single shot. These key work is generally used with the
bulk collections to enhance the preformance by minimizing
the I/O operations
| Is This Answer Correct ? | 5 Yes | 6 No |
What are algorithms provided by Microsoft in SQL Server?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is a linked cube?
What is a relationship?
Explain difference between e-r modeling and dimentional modeling?
When should one use an MD-database (multi-dimensional database) and not a relational one?
What are the fundamental elements of the data warehouse?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Where we use surrogate key explain with example?
What are the other names given to data warehousing?
How to provide security in frame work manager for a query subject?
How to know the time taken for particular report execution?
Teradata 
