Interested to Buy Any Domain ? << Click Here >> for more details...
what is the t-code to create INDEX in SAP BI(7.0)?/How can
we create the index in SAP BW/BI?
- 4 Answers
- 36483 Views
- Enteg Technologies, TCS, I also Faced
- E-Mail Answers
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
You want to convert bex query global structure to local structure. How would you do that?
How will you get more details on data source and delta modes?
Explain dash board?
You want to see the log of transport connection. What t-code would you use? List the steps.
What are the added features in 3.x for multi provider?
What is the option of ?pause Automatic Refresh??
What is sap bw/bi? What is the purpose of sap bw/bi?
What is the procedure to implement structural authorization in BW?
In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
Give an example of it?
Explain about the multi-provider in the sap?
What is a content extraction?
What are the system tools you can use?
What is update mode for master data?
What is the web download scheduler?
