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
- 36897 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
what are the drawbacks of cubes?
What is the program to maintain change run?
list the steps to do the extractig data from r/3.
Do you have any idea how to improve the performance of the bw?
What is bw statistics and how it is used?
What are the template options?
describe how you have used excel as a compliment to bex?
What are the options to calculate result as ? summation?
Why if one request fails, all the subsequent requests are turned to "red"?
What are tickets.
I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
What are the steps to do the creating classes in sap-bw.
What are conversion routines for units and currencies in the update rule?
What is a structure?
Differentiate between v1, v2, v3 jobs in extraction.
