What Is The Use Of Array Fetch Size?

1.	What Is The Use Of Array Fetch Size?
Answer» Array fetch SIZE indicates the number of rows retrieved in a single REQUEST to a source database. The default value is 1000. Higher numbers reduce requests, lowering network traffic, and possibly IMPROVE PERFORMANCE. The maximum value is 5000 Array fetch size indicates the number of rows retrieved in a single request to a source database. The default value is 1000. Higher numbers reduce requests, lowering network traffic, and possibly improve performance. The maximum value is 5000

Answer»

Array fetch SIZE indicates the number of rows retrieved in a single REQUEST to a source database. The default value is 1000. Higher numbers reduce requests, lowering network traffic, and possibly IMPROVE PERFORMANCE. The maximum value is 5000

Array fetch size indicates the number of rows retrieved in a single request to a source database. The default value is 1000. Higher numbers reduce requests, lowering network traffic, and possibly improve performance. The maximum value is 5000

Discussion

No Comment Found

Related InterviewSolutions

List Some Factors For Performance Tuning In Data Services?
What Must You Define In Order To Audit A Data Flow?
What Is The Use Of Case Transform?
What Is Heirarchy Flatenning?
What Is The Use Of Map-operation Transform?
What Is The Use Of History Preserving Transform?
What Is The Difference Between Lookup (), Lookup_ext () And Lookup_seq ()?
What Is The Use Of Rows Per Commit?
What Is The Use Of Using Number Of Loaders In Target Table?
What Are The Differences Between Row-by-row Select And Cached Comparison Table And Sorted Input In Table Comparison Transform?

What Is The Use Of Array Fetch Size?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment