Hi,

>hmm, and how do you do with foreign key that have only very few
>value? cause foreign key automatiquelly create index !

You use some sort of 'trick' like:


select <fields> from <table>
where <some_indexed_condition>

and your_integer_field_you_do_not_want_to_use_index+0 = some_value

(..or..)

and your_varchar_field_you_do_not_want_to_use_index||'' = 'some_value'



Regards,
Anderson Farias