Pro Tips on Managing Data at Scale
As a DBA I worked on a number of projects fighting fires and putting them off successfully. However in the beginning of my career I was not sure where to start, as I matured as a DBA there is a pattern that developed to troubleshoot performance issues. Each of the following areas need different kind … Read more
Problem: How would you generate a report of the top 10 most active tables of your DB2 database ? To be more precise how would you generate a list of top 10 tables that are being Read/Inserted/Updated/Deleted and also against which most table scans are happening ? Solution: Use the following SQL to generate a … Read more
Problem Statement: A redundant index in my book can have one or more leading columns that match with any other existing index leading columns on a given table. As a DBA I worked in many places where this is a reccurring problem. Many DBA’s are hesitant to drop these redundant indexes despite number of disadvantages … Read more
By continuing to use the site, you agree to the use of cookies. more information
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.