hints in inline query

From: Umar FArooq <umar.farooq_at_cressoft.com.pk>
Date: Fri, 12 Jun 1998 13:25:08 +0500
Message-ID: <3580E5E4.EA31AE3A@cressoft.com.pk>

Hi:
I have to tune a query of the form
select * from tab1 a, (select * from tab2) ...

The outer query is working fine but the subquery (inline query) is causing problems..i wish to know that if i add hints after teh SLECT clause of the subquery then will it perform accordingly or not. If not then how do I tune the subquery.

Also, if my query is using a view...how should I tune the view

Thx.

Umar Farooq Ch.
umar.farooq_at_cressoft.com.pk Received on Fri Jun 12 1998 - 03:25:08 CDT