if you use "is null" or "is not null" in where predicates
oracle doesn't use index instead full table scan will be only solution.
Bye
On Thu, 30 Nov 2000 11:25:27 -0800 sonia pajerowski <spajerowski_at_yahoo.com> wrote:
> Hello,
> I have a table with 5 columns and also have 5 views
> based on these columns.
>
> Views basically do a
>
> select count(*), test from mytest
> where test is null
> group by test
> or
> select count(*), test from mytest
> where test is not null
> group by test
>
> Explain plan shows the same path (FULL TABLE ACCESS)
> before and after creating index on the column test.
> The tabe has less than 100 rows and that might be the
> reason for full table access or is it something else I
> might be missing.
>
> Query Plan
> --------------------------------------------------------------------------------------
> SELECT STATEMENT Cost =
> SORT GROUP BY
> TABLE ACCESS FULL MYTEST 1
>
> Thanks
> Sonia P.
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
> http://shopping.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: sonia pajerowski
> INET: spajerowski_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Sun Dec 03 2000 - 04:31:04 CST
