Scenario:
AIX, 8.1.6.3.
Cognos cube building going on.
select count(*) from ft_sales, shows up 0 rows, its using a bitmap index out
of the explain plan.
I force full table scan or force to use other bitmap index, or PK(normal
index) and it comes back with correct count(20+ million).
Anyone seen anything like this before?
thanks, joe
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph Testa
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
