Hint

Hi all,

I am trying to run a select statement which joins three tables A, B and C. These tables are all very large. Each have a couple of indexes. I heard that Oracle will always optimize the search and has its way of deciding which indexes to use. I also heard that we can give oracle a list of indexes to consider. Could anyone tell me what the syntax is, say I want to perform a join between tables Am, B and C and if A has indexs, A1, A2 and B has B1, B2 etc. How do I hint ROacle to optimize the seaachh with respect to only index A1, B2, abd C3 ?

Thanks in advance,
chari

MZ Received on Sat Dec 07 1996 - 00:00:00 CET