0

I am trying to design a DW Process and I heard about Indexed views. Actually I want to create a view and it should update automatically when base tables are changed.

Basically, all I need to do is:

  • Want to create a regular view
  • Then, Want to create a clustered index on that view

Can explain with an query example..

NEO
  • 389
  • 8
  • 31
  • 1
    That isn't supported. The last time I used an indexed view was in the late 90's with SQL Server because they didn't support partitioning. Greenplum supports multi-level partitioning so you don't need an indexed view. – Jon Roberts Jul 10 '17 at 14:19
  • Great thanks to you. – NEO Jul 10 '17 at 16:27

0 Answers0