What a view actually stores
You create a view:
sql
CREATE VIEW active_students AS
SELECT id, name, college_id
FROM students
WHERE status = 'ACTIVE';
The students table has 40,000 rows, of which 31,200 are active. How much
disk does active_students consume immediately after this statement?