Anonymous
Asked in
Cars &Transportation
·
2 weeks ago
Why do we use view instead of tables?
Contents
- Why do we use views?
- What is the difference between a view and a table?
- Which is faster view or table?
Why do we use views?
Views are used for security purposes because they provide encapsulation of the name of the table. Data is in the virtual table, not stored permanently. Views display only selected data. We can also use Sql Join s in the Select statement in deriving the data for the view.
What is the difference between a view and a table?
A table is structured with columns and rows, while a view is a virtual table extracted from a database. The table is an independent data object while views are usually depending on the table. The table is an actual or real table that exists in physical locations.
Which is faster view or table?
reading from a view allows the SQL to be rewritten.. and it's generally FASTER to read from a view (than from a dump of the view).
Related Questions
Relevance
-
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago -
Anonymous2 weeks ago
Expert answer2 weeks ago
Write us your question, the answer will be received in 24 hours