Тёмный

Improve Webi Performance with Index Awareness : SAP BusinessObjects 

aroundBI
Подписаться 13 тыс.
Просмотров 12 тыс.
50% 1

Index awareness is the ability to take advantage of the indexes on key columns to
speed data retrieval. We set up index awareness in Designer for object definitions and tell Designer which database columns are primary and foreign keys. Report query can take advantage of the indexes on key columns to speed query results.
It is one of ways to improve webi query performance.

Опубликовано:

 

13 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 12   
@MohanMohan-bx4dw
@MohanMohan-bx4dw Год назад
Thank you very much. You are explaining in detail and can one understand easily
@appanaganesh2310
@appanaganesh2310 4 года назад
Nice explanation, u deserve a big thanks
@sonutvv
@sonutvv 2 года назад
Your tutorials are so helpful. Thanks.
@MohanMohan-bx4dw
@MohanMohan-bx4dw Год назад
please make some more videos on SAP BO
@ashwinik9459
@ashwinik9459 5 лет назад
Thank you so much sir :-) it helped a lot.
@tamboliashish
@tamboliashish 6 лет назад
what if the selected state is present in the state table but that does not have any fact data and hence if it is not present in the fact table? will it make a join of the 2 tables in the sql
@SHON1101
@SHON1101 7 лет назад
How does it work if same primary key is used in multiple tables as foreign key. Can we add multiple foreign keys there?
@lalithasekar7788
@lalithasekar7788 7 лет назад
Could you explain on relevance between merged dimensions and index awareness on objects
@aroundBI
@aroundBI 7 лет назад
If I am understanding your question on relation between merged dimensions and index awareness on objects, Index awareness feature is used while query generation while merge dimensions works on outcome of multiple queries.
@mrknownothing2470
@mrknownothing2470 7 лет назад
What is the version of the IDT tool in this demo?
@aroundBI
@aroundBI 7 лет назад
We are at BI4.1 SP6.
@vikrammagoo
@vikrammagoo 4 года назад
Good concept .....but why you are in so hurry?