on 09-17-2014 10:23 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.