ETL Preformance Tuning : Identification of Performance Bottleneck
Atul Singh
February 27, 2017
The goal of performance tuning is to optimize session performance by eliminating performance bottlenecks. To tune the performance of a sess...
Showing posts with label Tuning. Show all posts
Showing posts with label Tuning. Show all posts
Monday, February 27, 2017
Wednesday, June 15, 2016
5 Tips For Better DataStage Design #14
Atul Singh
June 15, 2016
1. The use of Lookup stage depends upon the volume of data.Sparse lookup type should be used when primary input data volume is small.If th...
Tuesday, June 7, 2016
Tuning SQL Statement #4
Atul Singh
June 07, 2016
Using Functions in Queries When using functions in SQL statements it is best to keep the functions away from any columns involving index m...
Sunday, May 22, 2016
Tuning SQL Statement #3
Atul Singh
May 22, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #2....... Consider whether a UNION ALL will suffice in place of a UNION. The UNION ...
Tuesday, April 26, 2016
Tuning SQL Statement #2
Atul Singh
April 26, 2016
Tuning SQL Statement #1....... Tuning SQL Statement #3....... • The UNION statement performs the equivalent of a SELECT DISTINCT on t...
Monday, April 25, 2016
Tuning SQL Statement #1
Atul Singh
April 25, 2016
• Try to use explicit columns and try to read columns in index orders if possible, even to the point of reading indexes and not tables....
