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
How do you activate personalization for bex?
When we use condition the totals do not match why?
In real world when do you recommend aggregate?
What is infoobject catalog?
How can you navigate to see the error idocs?
What is the process chain and when you can use the same in the data warehouse?
What is the use of multi-provider in the sap?
What are the monitor settings?
How do you convert from LIS to LO extraction?
what do you mean by update routines
What is write optimized dso?
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
What is the difference between ods and info-cubes?
How would you do the optimizing the dimensions
What are intervals?