Question: what is the difference between index and view?
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.