pureQuery for IDS: Check out the updated tutorial
IBM_Optim 27000269HS Visits (4207)
We talk about the benefits of static SQL execution as a benefit of using Data Studio Developer and pureQuery. And those benefits are great. But if you're an Informix developer or DBA, you may still be wondering if Data Studio Developer can help you improve application performance, since IDS doesn't currently support DB2's static execution model.
When we announced Data Studio Developer 2.1, we added many features that benefit Informix database developers and DBAs. Guy Bowerman covered some of the key 'base' features for both developers and DBAs, including support for UPDATE STATISTICS, improved support for triggers and tablefragmentation. But if you're a Java database developer or DBA who cares about performance, take a look at pureQuery capabilities for Informix as well, including: