Ok, let's say I have three different queries that all return the same result set.<BR><BR>One uses a temp table, the other a correlated subquery, and the third is just a HUGE set of union queries, etc.

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

The book, Object Oriented Application Development Using the Caché Postrelational Database, spotlights a database system that runs on Red Hat or TurboLinux with an unusual set of both object-oriented ...

Ok some details on my part:<BR><BR>I don't have to develop for it or put any information in the Cache system. It's being used a a data dump for OLTP system, kinda of a cheap ass data warehouse. I get ...