Strange execution plan picking random index to do bitmap conv on.

[Sorry, also posted with the wrong subject title - RE: (un)intelligent agent] Hi all, Does anyone have an idea why the query is picking a random local bitmap index whose single column is not used in the query to do a conversion on? Regards, Adrian --- SELECT 1 FROM

RE: Strange execution plan picking random index to do bitmap conv on.

Sorry, its late on Friday and need beer... The bitmap index is partitioned in INV5. -Original Message- Sent: 07 November 2003 15:30 To: Multiple recipients of list ORACLE-L on. [Sorry, also posted with the wrong subject title - RE: (un)intelligent agent] Hi all, Does anyone have an