Re: Materialized View
From: Randolf Geist <mahrah_at_web.de>
Date: Sun, 25 Oct 2009 06:24:01 -0700 (PDT)
Message-ID: <d863e691-1881-4c28-a1f9-708bbc0f7b9b_at_l34g2000vba.googlegroups.com>
On Oct 24, 12:56 am, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> Hope I can explain this properly:
>
> I'm hoping this can be done in just 1 long SQL statement. We have
> several queries that gather counts from different tables. Each takes
> a while and since they are part of the same app, the screen takes a
> while. So, we want to use a materialized view.
>
> Problem is that each column would need to be a query. The tables are
> different, though we basically need the same data from them, a date
> and a count of records on that date. So, each query will return
> different results, but yet we want 1 materialized view to contain the
> counts of the 6 tables. For example, here are 2 of the queries:
Date: Sun, 25 Oct 2009 06:24:01 -0700 (PDT)
Message-ID: <d863e691-1881-4c28-a1f9-708bbc0f7b9b_at_l34g2000vba.googlegroups.com>
On Oct 24, 12:56 am, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> Hope I can explain this properly:
>
> I'm hoping this can be done in just 1 long SQL statement. We have
> several queries that gather counts from different tables. Each takes
> a while and since they are part of the same app, the screen takes a
> while. So, we want to use a materialized view.
>
> Problem is that each column would need to be a query. The tables are
> different, though we basically need the same data from them, a date
> and a count of records on that date. So, each query will return
> different results, but yet we want 1 materialized view to contain the
> counts of the 6 tables. For example, here are 2 of the queries:
If this is still about the query that you have asked about in your previous thread: I've updated that old thread how I think you can speed up that query, may be then you don't have the need for an additional materialized view.
Regards,
Randolf
Oracle related stuff blog:
http://oracle-randolf.blogspot.com/
SQLTools++ for Oracle (Open source Oracle GUI for Windows):
http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/
Received on Sun Oct 25 2009 - 08:24:01 CDT