Re: Full scan vs index
From: David Ramírez Reyes <dramirezr_at_gmail.com>
Date: Thu, 10 Oct 2013 08:47:39 -0500
Message-ID: <CAJt=wvU9hhBSo-gv8HFgK6RzJktjW-hMpnyNLEzm9cxt-SWiAA_at_mail.gmail.com>
That's why the explain plant of the query forcing the index usage is important, "ideally" the cost should be bigger than using the full scan....
Date: Thu, 10 Oct 2013 08:47:39 -0500
Message-ID: <CAJt=wvU9hhBSo-gv8HFgK6RzJktjW-hMpnyNLEzm9cxt-SWiAA_at_mail.gmail.com>
That's why the explain plant of the query forcing the index usage is important, "ideally" the cost should be bigger than using the full scan....
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 10 2013 - 15:47:39 CEST