explain and view

Dmitry Melekhov <[email protected]> Thu, 18 Sep 2003 16:11:29 +0500
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]>
Hello!

If we create view1 as select from view2
explain doesn't show execution plan  for view2.

Does it mean that optimizer will use plan, which it shows in
explain select from view2?

btw, I ask this question just beacause we need to do some optimization-
the same data and queries on Oracle works  100 and more times faster 
than in SAP DB
(4 minitues compared with 3 seconds)