Query on INDEX SET

kanna n · New User Joined: 04 Oct 2007 Posts: 12 Location: pune

HI,

if i define an Index set as below.......

what is that 12 keys?? how to calculate that count.

ADD
SET NAME IS ABCDEF
ORDER IS SORTED
MODE IS INDEX BLOCK CONTAINS 12 KEYS
OWNER IS SYSTEM
WITHIN AREA WXYZ-AREA OFFSET 0 PERCENT FOR 100 PERCENT

can any one please help me in this ??

thanks in advance..

Shaheen Kalokhe · New User Joined: 21 Feb 2008 Posts: 21 Location: India

Hi Kanna,

The Keys that you have in the Index are one/more Fields that are part of your Actual Physical Record. The key(s) tells us the fields on which the Index record is sorted.

kanna n · New User Joined: 04 Oct 2007 Posts: 12 Location: pune

thanks.

but is there any algorithm or formula to calculate that key count??
if so how.

Shaheen Kalokhe · New User Joined: 21 Feb 2008 Posts: 21 Location: India

As per my knowledge there are no algorithms, the DBA'S decide the sort keys when designing the databse as per the requirements.