IBM TechXchange Community Together, we can connect via forums, blogs, files and face-to-face networking. Find your community
Learn how to create/drop virtual indexes without impact to improve your SQL statements. This article was written by Tom Hubbard #Db2Toolsforz/OS #db2sqlpa #Db2Tools
Testing Virtual Indexes with IBM SQL Performance Analyzer.pdf
Did you know that SQL Performance Analyzer gives you the ability to use virtual index configurations to calculate the impact that those change might have on the cost of your SQL? SQLPA supports the ability to both virtually drop real indexes and/or create new virtual indexes. This gives you the...