Home » RDBMS Server » Performance Tuning » Bitmap conversion
Bitmap conversion [message #355121] Wed, 22 October 2008 14:06
ArvindBhope
Messages: 55
Registered: June 2008
Member
Hello All,

alter session set "_b_tree_bitmap_plans"=FALSE;

alter session set star_transformation_enabled = FALSE ;

One of the query is going for bitmap conversion even after disabling the above parameters. please help

displayed is the sameple output of the plan .

| 18 | BITMAP CONVERSION FROM ROWIDS| | | | | |
|* 19 | INDEX RANGE SCAN | IDX_FTB_ORDER_DIM_PGK | 1 | | 2 (0)| 00:00:01 |
| 20 | BITMAP CONVERSION FROM ROWIDS| | | | | |
|* 21 | INDEX RANGE SCAN | IDX_FTB_ORDER_DIM_PGK | 1 | | 2 (0)| 00:00:01 |
| 22 | BITMAP CONVERSION FROM ROWIDS| | | | | |
|* 23 | INDEX RANGE SCAN | IDX_FTB_ORDER_DIM_PGK | 1 | | 2 (0)| 00:00:01 |
| 24 | BITMAP CONVERSION FROM ROWIDS| | | | | |
|* 25 | INDEX RANGE SCAN | IDX_FTB_ORDER_DIM_PGK | 1 | |



thanks,
Arvind

Report message to a moderator

Previous Topic: response time
Next Topic: Looking for a better access method
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 08:45:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.