Trying to do a STRAIGHT JOIN to force an INDEX

I have a query similar to the one below. Im trying to force a STRAIGHT JOING to Table5 which has an index on Id Date. For some reason, the optimizer isnt picking the INDEX to execute the query (and subsequently doing a full scan on a 250 million+ row table) so Im trying to force the STRAIGHT

Re: Trying to do a STRAIGHT JOIN to force an INDEX

David Perron wrote: I have a query similar to the one below. Im trying to force a STRAIGHT JOING to Table5 which has an index on Id Date. For some reason, the optimizer isnt picking the INDEX to execute the query (and subsequently doing a full scan on a 250 million+ row table) so Im trying to