>The index expression is a large string..
>
>I'm using:
>
>BINTOC(table1.primarykey) + BINTOC(table1.secondarykey) + BINTOC(table2.primarykey) + BINTOC(table2.secondarykey) + BINTOC(table3.primarykey) + BINTOC(table3.secondarykey)
>
>Are you saying I can get the same result from a different, smaller index expression but still reference these three tables and all 6 fields?
looking at your index i'd say that it is impossible. also, isn't this type of index violation of table normalization?
at least, it looks to me like bad practice to index one table with data from another tables...
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer