view and materialized view

[Former Member]

Hi Experts,

1.Difference between Table and View.

2.Difference between View and materialized view.

3.Is it possible to update the data using view.

Could you please any one help me..

Thanks&Regards

Ramesh

[Former Member · Accepted solution]

a) The database table has a physical existence in the database.

b) A view is a virtual table, that is one that does not actually exist. View is made up of a query on one or many tables in a database.

c) materialized view stores the results of the SQL in table form in the database. where as view stores the SQL.

SQL statement only executes once and after that everytime you run the query the stored result set is used. which improve the performence.

Updating the data using the view is not possible as view is depend on base table. You can perform DML on the view but not using the view.

[Dev · Accepted solution]

While I am trying to create an MV my Hana doesn't recognizes it's syntax and we are on sap bw 7.5 sp 20 on Hana 2.3. May I know if materialisation doesn't support here?