what is the t-code to create INDEX in SAP BI(7.0)?/How can
we create the index in SAP BW/BI?

Answer Posted / durgaprasad

Index-- use to locate needed records from database tables
quickly.BW uses two types

---1. bitmap and 2. B-tree.

b-tree is for regular database tables and bitmap is for fact
tables and aggregate tables

Bitmap index - Bit map index uses maps of bits to locate
records in table.This indexs are very effective for Boolean
operators of where class of a select statement.when the
codinalality of a collum is low bit map index size will be
small there by reducing i/o volume.(which improves the
performance)

Is This Answer Correct ?    8 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you activate personalization for bex?

2210


When we use condition the totals do not match why?

1536


In real world when do you recommend aggregate?

1867


What is infoobject catalog?

536


How can you navigate to see the error idocs?

477






What is the process chain and when you can use the same in the data warehouse?

457


What is the use of multi-provider in the sap?

481


What are the monitor settings?

1525


How do you convert from LIS to LO extraction?

2500


what do you mean by update routines

492


What is write optimized dso?

549


I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is

932


What is the difference between ods and info-cubes?

466


How would you do the optimizing the dimensions

476


What are intervals?

1496