Re: A transactionally consistent view on real-time data with MicroStrategy

From: <xhoster_at_gmail.com>
Date: 05 Jun 2006 16:43:42 GMT
Message-ID: <20060605125224.407$kG@newsreader.com>

erik.ykema_at_gmail.com wrote:

>

> A typical MSTR generated SQL scenario could look like this:
> alter session set isolation_level = serialized; -- my addition, trying
> to get it right, using a custom pre-report SQL statement
> create table A1 as select from A;
> create table B1 as select from B;
> create table C1 as select from C;
> create table Z as select from A, B, C fully outer joined;
> drop table A1, B1, C1;

A1, B1, and C1 are never used between the time they are created and the time they are dropped. What is the point?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB

Received on Mon Jun 05 2006 - 11:43:42 CDT