Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 27 Jul 2012 @ 10:43:31 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Materialized view and view
From:   Satyendra.Kumar

Hi Sughesh,

There is no such concept in the materialized view directly in TD, but we can achieve it using Join Index.

As you might be aware with view that it is nothing but the replica of table/tables created for specified purpose.

Join indices are maintained when the data is maintained. They cannot be accessed directly, but are invoked when the optimizer determines it is beneficial. Even though you cannot invoke a join index directly, you create a view that looks like the join index and in that way, it would be similar to having direct access.

Thanks and Regards,

Satyendra Kumar

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019