What SQL query building tools can be used with QD?
Any SQL query tool that is compatible with SQL-92 will work with QD the same way it would work with any other RDBMS. • How can QD be leveraged when an enterprise already has query applications in place? That’s the best environment for QD. Enterprises with large, busy databases find that they cannot run the kinds of ad hoc queries that they want to. Often those queries can run for hours or days and seriously impact the performance of the production database. Since QD contains a complete database and runs on a local desktop or laptop, analysts are free to run queries against it without impacting production. They can take the time to develop complex queries, even making incremental improvements to the queries and rerunning them freely, without fear of affecting production. Unlike a standard transaction-based database, QD is optimized for these queries. • If I have query applications in place today, how can I leverage a QD compressed database? Where pure SQL is employed in a query applicat
