Actually, once you start joining views, you often loose the primary keys and indexes.
Even if they're in there, a complex view can befuddle a parser. Worst case, the entire view is run and loaded into temp for the join with zero indexes. It's ugly. I keep telling them, "Views are evil." I'm thinking it will be lecture time tomorrow.
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
no subject
Date: 2005-09-26 01:18 pm (UTC)Even if they're in there, a complex view can befuddle a parser. Worst case, the entire view is run and loaded into temp for the join with zero indexes. It's ugly. I keep telling them, "Views are evil." I'm thinking it will be lecture time tomorrow.