undefined | Better HN

0 pointsmumblemumble6y ago0 comments

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.

0 comments

2 comments · 1 top-level

wodenokoto6y ago· 1 in thread

Bigquery.

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.

mumblemumbleOP6y ago

Ah. 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.

j / k navigate · click thread line to collapse