Question: what is the difference between view and index in sql?
Answer: An index helps speed up SELECT queries and WHERE clauses, but it slows down data input, with UPDATE and INSERT statements. Indexes can be created or dropped with no effect on the data. view: 1) view is also a one of the database object.