Index

From: sonia pajerowski <spajerowski_at_yahoo.com>
Date: Thu, 30 Nov 2000 11:24:41 -0800 (PST)
Message-Id: <10696.123347@fatcity.com>

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. Received on Thu Nov 30 2000 - 13:24:41 CST