Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized Views: Refreshing same MV by 2 calls to DBMS_MVIEW.REFRESH at the same time.
AEH wrote:
> The goal for using a materialized view is provide a smaller group of
> data for the search to run against so that it doesn't have to do all of
> the ugly joins within the search itself.
>
> Because this is a user facing search it needs to be as quick as
> possible so creating a subset of records to join against is useful.
>
> If the session had been persistant I would have loaded all the data for
> that user into a Global temp table when they logged in and then
> updated that table as they created transactions in the system, and then
> joined the search criteria against that. However the session isn't
> persistant so a Global Temp isn't an option. So I'm left with something
> that works but I don't like or a MV which I haven't worked with before.
>
>
>>And as readers don't block writers, writers don't block readers, and >>readers most certainly do not block readers, you can query anything >>you like. Unless you meant something different, of course.
Non-persistent connections, searches... sounds like
a web application with a search screen.
If so, I'd urge you to look into InterMedia Text.
-- Regards, Frank van BortelReceived on Wed May 18 2005 - 14:09:28 CDT