Menu
I have a view that is created from a base table.This view is basically the exact copy of table without any filter conditions and it has all the columns and records of the table.
Is there any advantage in using view (which is a direct copy of table) instead of the table directly in my application or stored procedures.
829
Views are generally used to focus, simplify, and customize the perception each user has of the database. Views can be used as security mechanisms by letting users access data through the view, without granting the users permissions to directly access the underlying base tables of the view.
Views are virtual tables that can be a great way to optimize your database experience. Not only are views good for defining a table without using extra storage, but they also accelerate data analysis and can provide your data extra security.
Views can provide advantages over tables: Views can represent a subset of the data contained in a table. Consequently, a view can limit the degree of exposure of the underlying tables to the outer world: a given user may have permission to query the view, while denied access to the rest of the base table.
Views are a special version of tables in SQL. They provide a virtual table environment for various complex operations. You can select data from multiple tables, or you can select specific data based on certain criteria in views.
But you need to be aware that the way views work is a bit different, as you end up having some overkill on the DB side.
The way a view works, is by doing a Select *, and then filtering itself for the columns you are adding to it.
I'd be really weary to use views for this, unless there were some serious security concerns.
The way to go is to create a Stored Procedure that grabs the data directly from the table. That way, you can take the maximum of index and all that.
Cheers
157
One advantage (or disadvantage, depending on your viewpoint) is that Views allow you to store business logic within the SQL server, instead of within your code. If you need to change the business easily without recompiling your code, modifying the view is a quick and easy way of doing so.
I personally prefer having the business logic of the application defined within the code however :)
43
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
