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
- 35749 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 is ?User master comparison? in roles?
What is partitioning and what are the benefits of partitioning in an infocube?
What is a number range object?
how bw was found
What are extractors?
What is translation key?
How does a navigational attribute differ from other attributes in terms of linking it with the infocube?
how to getweekday,weekmonth,month,weekno,week order in the report by using routines?
Do you have any idea how to improve the performance of the bw?
Which of the tables are inside and outside cube in an extended star schema?
How do you transform OH data?
How do perform real-time data acquisition in a bw system?
What are tickets.
What are the template options?
What does the VARIABLE_SCREEN URL parameter do?
