View:

• A virtual table created by a query.
• Does not store data; instead, it pulls data from existing tables whenever accessed.
• Used for simplifying complex queries, enhancing security, and providing a specific data perspective.
• Can be queried like a regular table but cannot always be updated.

Index:

• A data structure that improves the speed of data retrieval.
• Stores pointers to data in tables, helping speed up queries that involve searches or sorting.
• Used to improve performance but can slow down write operations (like INSERT, UPDATE).