What is the difference between a Table and a View?
Answers were Sorted based on User's Feedback
Answer / guest
Table contains all the row. View doesn't contain any data
but rather an SQL statement that is executed every time the
View is accessed. It provided row level security for
accessing information.
The downside is lost performance as compared to a Table
| Is This Answer Correct ? | 14 Yes | 3 No |
Answer / jagdish prajapati
Table is Physical Stored. but View is logical or virtual
Stored.
| Is This Answer Correct ? | 9 Yes | 1 No |
Can you tell few best practices to be followed for optimization in sql?
What is mysqli_connect_error ()?
How many threads can mysql handle?
How do I rename a table in mysql?
How many rows can mysql handle?
what do you mean by longblob Data type in MySql?
Does adding an index lock a table?
What is the use of mysqli_fetch_assoc?
Where is the myisam table stored?
List data types in mysql? Explain
How to load a csv file into a table
What is the latest version of mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)