cancel
Showing results for 
Search instead for 
Did you mean: 

WHERE clause in index awareness key definition

Former Member
0 Kudos

On the "Keys" tab of a business layer object definition, there are five columns: "Key Type," "SELECT," "WHERE," "Data Type," and "Active."

Four of the five columns are fairly self-explanatory once you understand index awareness, but I'm confused about the "WHERE" column.  When is it used, and what is its purpose? 

I've tried adding it to an object to understand its behavior, but so far it doesn't seem to have any effect.

For info, I'm working with a monosource universe in IDT on BI 4.1.

Accepted Solutions (1)

Accepted Solutions (1)

former_member190895
Active Participant
0 Kudos

Hi,

WHERE clause is used to put restriction on primary or foreign key index.

Please refer the below link which explain you the Where clause use in index awareness.

http://scn.sap.com/docs/DOC-22113

http://scn.sap.com/docs/DOC-22115

Former Member
0 Kudos

Thanks, Mantu, that shows what to expect in the generated SQL so that's very helpful.  I'm having trouble imagining when this would be useful from a functional standpoint, however; any ideas on that?

former_member190895
Active Participant
0 Kudos

Hi Emily,

It will useful if you want to put the restriction on certain primary key values even if the user selects all the values from the list.

former_member4998
Active Contributor
0 Kudos

HI


If you set up a WHERE clause restriction that will use the applied primary or foreign key index. And improves the performance.

If you Select Primary Key as Country ID and in the Where clause as Country ID, restriction will applied on primary Key as as for foreign key.

Answers (0)