{"id":108,"date":"2014-05-07T14:07:00","date_gmt":"2014-05-07T13:07:00","guid":{"rendered":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/07\/what-are-the-disadvantage-of-sql-views\/"},"modified":"2014-05-07T14:07:00","modified_gmt":"2014-05-07T13:07:00","slug":"what-are-the-disadvantage-of-sql-views","status":"publish","type":"post","link":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/07\/what-are-the-disadvantage-of-sql-views\/","title":{"rendered":"What are the disadvantage of SQL views?"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>34 Second <\/div>\n\n <\/div>
\n
\nAdvantages<\/b><\/span>:<\/b><\/span><\/span><\/div>\n

1. View the data without storing the data into the object.<\/span><\/span><\/p>\n

\n
\n2. Restrict the view of a table i.e. can hide some of columns in the tables.<\/span><\/div>\n
\n3. Join two or more tables and show it as one object to user.<\/span><\/div>\n
\n4. Restrict the access of a table so that nobody can insert the rows into the table.<\/span><\/div>\n
\n
<\/span><\/div>\n
\nDisadvantages<\/b><\/span>:<\/b><\/span><\/div>\n
\n1. dml is not possible if that is more than one table.<\/span><\/span><\/div>\n
\n2. When table is dropped view becomes inactive.. it depends on the table objects.<\/span><\/div>\n
\n3. it is also database object so it will occupy the space.<\/span><\/span><\/div>\n
\n4. Querying from view takes more time than directly querying from the table.<\/span><\/span><\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Advantages: 1. View the data without storing the data into the object. 2. Restrict the view of a table i.e. can hide some of columns in the tables. 3. Join two or more tables and show it as one object to user. 4. Restrict the access of a table so that nobody can insert the […]<\/p>\n","protected":false},"author":43,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[27],"tags":[],"class_list":["post-108","post","type-post","status-publish","format-standard","hentry","category-sql"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Himanshu Namdeo","author_link":"https:\/\/debuggersspace.com\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"Advantages: 1. View the data without storing the data into the object. 2. Restrict the view of a table i.e. can hide some of columns in the tables. 3. Join two or more tables and show it as one object to user. 4. Restrict the access of a table so that nobody can insert the…","_links":{"self":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/108"}],"collection":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/comments?post=108"}],"version-history":[{"count":0,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/108\/revisions"}],"wp:attachment":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/media?parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/categories?post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/tags?post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}