Re: SQL question
- From: gints.plivna@xxxxxxxxx
- To: "Karthik.Ramadoss@xxxxxxxxxxxxxxxx" <Karthik.Ramadoss@xxxxxxxxxxxxxxxx>
- Date: Wed, 24 Oct 2012 23:58:23 +0300
You may check what are the results with full hints on all 3 tables for both
selects (for count of course in the inner one). I agree that most probably some
index might be corrupted, so with full scans you should see the most credible
results.
Gints
On 2012. gada 24. okt., at 22:00, "Ramadoss, Karthik"
<Karthik.Ramadoss@xxxxxxxxxxxxxxxx> wrote:
> This is probably a simple one but definitely something new for me.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
