Chris Velevitch wrote:
> Why doesn't explain work with create views? There's nothing in the
> documentation saying it shouldn't.
>
No? The documentation for explain clearly states that the statement that follow the EXPLAIN
keyword is "Any SELECT, INSERT, UPDATE, DELETE, EXECUTE, or DECLARE statement". I don't see
CREATE (or any other ddl statement) in that list.
Regards,
Thomas Hallgren