Re: Sybase and materialized views
- From: "Carl Kayser" <kayser_c@xxxxxxx>
- Date: Mon, 12 Dec 2005 10:33:03 -0500
"DA Morgan" <damorgan@xxxxxxxxx> wrote in message
news:1134252669.433523@xxxxxxxxxxxxxxxxxxxxxx
> supergel wrote:
>> Hi
>> I'm new to Sybase from Oracle. Does Sybase have anything equivalent to
>> materialzed views? If not want is the best practice for creating views
>> with
>> huge amounts of data? Other than indexing the tables.
>> Thanks for help.
>
> For those not familiar with Oracle materialized views ... they are
> tables (not views) that refresh themselves based on a SQL statement
> based on criteria supplied during their creation. Multiple materialized
> views can be made to refresh as part of a single transaction so as to
> guarantee their data consistency.
>
> I too am looking for the answer.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan@xxxxxxxxxxxxxxxx
> (replace x with u to respond)
(1) It doesn't seem to exist in Sybase, at least with that name. (ASE 15.0
does have materialized [deterministic | computed] columns, but this seems
different from your description.)
(2) I imagine that the equivalent functionality could be done with triggers
on the base table(s) that would update the aggregate/dimension/whatever
"materialized view". Apparently Oracle materialized views are more
efficient than this approach?
(3) I would think that this capability is not best suited for OLTP (too
frequent activity) environments. And static tables can be created/updated
in batch DSS environments.
(4) Why does Oracle designate a table as a materialized "view"?
.
- Follow-Ups:
- Re: Sybase and materialized views
- From: Galen Boyer
- Re: Sybase and materialized views
- References:
- Sybase and materialized views
- From: supergel
- Re: Sybase and materialized views
- From: DA Morgan
- Sybase and materialized views
- Prev by Date: Re: bcp into syslogins
- Next by Date: Re: SELECT INTO tempdb..
- Previous by thread: Re: Sybase and materialized views
- Next by thread: Re: Sybase and materialized views
- Index(es):
Relevant Pages
|
