Message-Id: <10604.115913@fatcity.com> From: "Sandy Druar" Date: Wed, 30 Aug 2000 15:42:48 -0400 Subject: Re: Latch Free Problem - Need Help Diana, I tried using a hint to force the index to be used, but it changed the explain plan from hash join to 3 nested loops with the index. We are still getting Latch Free. I will try using the between. Any ideas will be more than helpful. Thanks, Sandy Druar Oracle DBA sdruar@eckerd.com