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
- 36702 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
I have 80 queries which query is taking so much time how can you solve it
What is occurence
What is data flow in bw/bi?
what is the component?
Usually we mention T or O in CONFIRMATION TYPE. What is T and O , stand for ?
How does it do delta?
What is bw statistics and how it is used?
Extraction in mm and SD and FI? What is the requirement and name them?
What is persistence mode in cache?
What are the SAP enhancements to enhance HR data?
You want to see if the execution of a query has been slow or fast. How would you do that?
What is transfer routines.
Describe your experience with the design and implementation of standard & custom infocubes.
what is high cardinality tell me brief
How do you check the alert monitor?
