by Anyone know how to get the ASA6 optimizer to use indexes on a view of a view?
If I run the outer view's select statement from ISQL it comes back in a couple
of seconds. If I select from the outer view, I havent seen it finish yet.
TIA,
klint.
--
+---------------------------------------+-----------------+
: Klint* : "Non rhyming :
: Snail : A.B.R.I. : possibilities :
: Mail University of New England : are useless" :
: Armidale NSW 2351 Australia : L.J.J. :
: Fax : +61 2 6772 5376 : :
+---------------------------------------+-----------------+