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