Skip to content

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?