Exorbitant Parsingtime for view

Dear all,

we have a rather complex View containing several UNIONs and 5-7 tables = per
FROM-clause. Now if I query

SELECT ...
  FROM my_view
 WHERE attribute =3D 'abc'

the parsing may need 1s. Execution about 0.5s. If I query=20

SELECT ...
  FROM my_view
 WHERE other_attribute =3D 'xyz' =20

the parsing needs 30-45s. Execution about 0.5s. Now I don't want = anybody to
understand our data model or that view. But does anyone has any hints, = where
to start searching? Any experience with such exorbitant parsing?

Thanx in advance

Mit freundlichen Gr=FC=DFen

i.A. Marc Blum

SOPTIM GmbH
Gr=FCner Weg 22-24
D-52070 Aachen

Telefon:	+49 241 / 9 18 79-33
Fax:	+49 241 / 15 40 38

mailto:marc.blum_at_soptim.de Received on Tue Oct 17 2000 - 07:17:09 CDT