Replacement for AND_EQUAL

  • From: Anand Rao <panandrao@xxxxxxxxx>
  • To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 Jan 2006 12:07:18 +0530

Hi folks,

AND_EQUAL hint is deprecated in Oracle 10g.

does anyone know if there is another suitable replacement for it?

or

should i replace it with INDEX_JOIN or INDEX_COMBINE hints?

sure will test the queries with both these hints, but i have 100s of them to
replace before i go live with 10g.

thanks
anand

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006