3 ms·
I'm curious, what DBMS are you using whose optimizer can't see through views? For what it's worth, MSSQL, PostgreSQL and Oracle don't have that limitation.
by mumblemumble 7y ago
I'm curious, what DBMS are you using whose optimizer can't see through views?
For what it's worth, MSSQL, PostgreSQL and Oracle don't have that limitation.
- wodenokoto 7y agoBigquery. If a make a view that joins table a and b, and I query that view with a filter, bigquery won’t push the filtering down unto a and b and then join.
- mumblemumble 7y agoAh. That's not too surprising, then, is it? Bigquery's column-oriented, so I imagine efficient row-selective queries isn't really what it's for in the first place.