Re: Sybase and materialized views

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)
.

Relevant Pages

  • Re: Sybase and materialized views
    ... "In August, Sybase demonstrated Jasper, the code name for the next edition ... of the SQL Anywhere mobile data management and synchronization solution. ... > views can be made to refresh as part of a single transaction so as to ...
    (comp.databases.sybase)
  • Sybase and materialized views
    ... I'm new to Sybase from Oracle. ... If not want is the best practice for creating views with ... Prev by Date: ...
    (comp.databases.sybase)
  • Re: Sybase and materialized views
    ... 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? ...
    (comp.databases.sybase)