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
Previous Topic: response time
Next Topic: Looking for a better access method
Goto Forum:
  


Current Time: Thu Dec 08 04:04:11 CST 2016

Total time taken to generate the page: 0.12446 seconds