Views and Indexes
Use views for reusable queries and indexes for faster lookups.
Views and Indexes
Views simplify repeated queries. Indexes can improve read performance when searching or filtering large tables.
sql
CREATE VIEW active_students AS
SELECT id, name, email
FROM students
WHERE is_active = TRUE;
CREATE INDEX idx_students_email ON students(email);