Question: what is difference between index and view in sql?
Answer: view contains logical data of a base table. ... It can be used in any SELECT statement like a table. index: 1) indexes will be created on columns.by using indexes the fetching of rows will be done quickly.