Re: SQL question
From: <gints.plivna_at_gmail.com>
Date: Wed, 24 Oct 2012 23:58:23 +0300
Message-Id: <F9A2B5EA-AFF6-43EE-B06A-1A384D88635C_at_gmail.com>
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.
Date: Wed, 24 Oct 2012 23:58:23 +0300
Message-Id: <F9A2B5EA-AFF6-43EE-B06A-1A384D88635C_at_gmail.com>
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_at_accidentfund.com> wrote:
> This is probably a simple one but definitely something new for me.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 24 2012 - 22:58:23 CEST