Difference between Database view and Table

[Former Member]

Hi there,

Can anyone tell me the difference between Database view and Table.

Will the Database view query be more faster than a database table?

[dani_mn]

HI,

database view is a logical defination of table it does not exists physically in the database. it gets its value from the database depending on its defination. and joins used.

database table pysically exists in the database and contains data.

Query for view is easiar than than database tables if you are using joins between different tables, because you have defined joins in the view defination and systems picks the data in optimize way using all key fields.

So view is better and easier.

Regards,

[anversha_s]

hi,

databse view - it is a window to a database table.

advantage : improve performance. faster access.

dis advat : cant chnage the table properties thru view.

rgds

anver

if hlped rwd points

[Former Member]

Hi,

View is better than table.

Using View u can avoid extra codings in ur program(u can avoid Joining conditions in program).

Also View has faster access.

Regards

Divakar

[Former Member]

Tables and database views can be defined in the ABAP Dictionary.

These objects are created in the underlying database with this definition. Changes in the definition of a table or database view are also automatically made in the database.

Data from several tables can be combined in a meaningful way using a view (join).

You can also hide information that is of no interest to you (projection) or only display

those data records that satisfy certain conditions (selection).

Database views implement an inner join. You only get those records which have an

entry in all the tables included in the view.

in views db modifications are not possible

views only contain data at run time

when they consult the database

in case of views the join definitions are already sstored in the database itself

whereas join as open sql is a query to oracle database as similar select statements

Views are optimized by SAP and stored in the repository while Joins

are in reports that needs to be compiled at every execution

Reward if helps

Regards,

Senthil

Message was edited by: senthil kumar

[Former Member]

Originally, in database theory, a view is a read only virtual or logical table composed of the result set of a query. Unlike ordinary tables in a relational database, a view is not part of the physical schema: it is a dynamic, virtual table computed or collated from data in the database. Changing the data in a table alters the data shown in the view.

Views can provide advantages over tables;

. They can subset the data contained in a table

. They can join and simplify multiple tables into a single virtual view

. Views can act as aggregated tables, where aggregated data (sum, average etc.) are calculated and presented as part of the data

. Views can hide the complexity of data, for example a view could appear as Sales2000 or Sales2001, transparently partitioning the actual underlying table

. Views do not incur any extra storage overhead

Depending on the SQL engine used, views can provide extra security.

reward if u find answer suitable