View previous topic :: View next topic
|
Author |
Message |
mailsaurabh.tripathi
New User
Joined: 22 May 2008 Posts: 56 Location: hyderabad
|
|
|
|
Hi
If an index is having a low first key cardf, relatively small as compared to the full cardf, then how good is that index? |
|
Back to top |
|
|
mailsaurabh.tripathi
New User
Joined: 22 May 2008 Posts: 56 Location: hyderabad
|
|
|
|
Col Name Null Type Colcard
1 PROMO Y INTEGER 11063
2 DETAIL_ID N INTEGER 22528
3 DETL_TYP N SMALLINT 5
4 IM_ID N DECIMAL(14,0) 36864
5 LOCATION N SMALLINT 1
6 ZONE N INTEGER 759
7 AREA N CHAR(3) 51 |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
It depends :
How many matching Cols is that index (mostly) used
Is the index used in Sort Avoidance
Is the index used for R.I. checking
A low firstkeycardf says very little about the "quality" of an index. |
|
Back to top |
|
|
|