Re: Sybase and materialized views

"Galen Boyer" <galen_boyer@xxxxxxxxx> wrote in message
news:u1x05q18g.fsf@xxxxxxxxxx
> On Wed, 21 Dec 2005, kristiandamm@xxxxxxxx wrote:
>>
>> If on the other hand, the view is based on a number of other tables,
>> each of may have data inserted and updated independently, I would be
>> more wary of such an undertaking. The complexity of the maintenance
>> could be great indeed, even without considering problems with
>> multithreaded updating: syncronisation, locking, etc.
>
> Multiple tables aren't an issue with Oracle for Materialized Views.

Meaning - I suppose - that Oracle has no problems materializing a view,
regardless of the complexity and number of tables in the defining select.

I know that.

I was simply presenting som considerations on how to implement something
like materailized views in Sybase ASE.

Regards,
Kristian Damm Jensen


.

Relevant Pages

  • Re: Oracle Text Search Across Multiple Columns and Different Tables
    ... Bellas wrote: ... I'm working on a general site seach which needs to search up to about ... issue using a materialized view for Oracle Text search? ... Regardless, I think that if your MV is fast-refreshable (that is, ...
    (comp.databases.oracle.server)
  • Re: Any interest in sparse K-Map issues? (or how to make a guess)
    ... accuracy with as few questions to the Oracle as possible. ... terms in the simplest sum of products form of the formula or its ... doesn't help us compute the complexity. ...
    (comp.ai)
  • Re: nice work Jessi Witt
    ... > with a degree of complexity which, chances are, you don't understand. ... Regardless of anyone's expertise in the field of psychology, ... these things take much time and effort and i envy the ...
    (rec.sport.disc)
  • Re: Oracle 10g RAC performance
    ... conclusion they need Oracle. ... have the idea that since Oracle is pushing RAC to everybody, ... risk more layers of complexity adds. ... a full time DBA just to manage a database. ...
    (comp.databases.oracle.server)
  • Re: Analytical Firing Solution...
    ... but I want the analytical way first, regardless of complexity and ... flexibility issues that may arise. ... What are the facts, and to how many decimal places?" ...
    (comp.games.development.programming.algorithms)