| jayesh |
Posted: Jan 07, 2008 10:15:54 AM |
Total Post: 60
Joined: Jan, 2008
|
| what is the difference between normal index and binary index pls tell me. thanx in advance. |
|
|
 Mohammed Taj |
| Posted: Jan 07, 2008 10:39:35 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
what is binary index.
did you mean "bitmap index"?
|
|
|
|
|
| jayesh |
| Posted: Jan 08, 2008 08:48:48 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
Sorry it was actually bitmap index...
now can u help me out.
|
|
|
|
|
| raja |
| Posted: Jan 08, 2008 11:44:25 PM | |
|
Total Post: 2
Joined: Nov, 2007
|
The difference between BINARY and BITMAP indexes :
U can create a Binary index on particular column of a table when the column data for each record is mostly different
example : salary column in employee table will have different values mostly, so its best to create a binary index on that column
U can create a Bitmap index on particular column of a table when the column data for each record is mostly same
example : sex(m/f) column in employee table will have only two possible values so its relevent to create a bitmap index on that column
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
