Hi
How many distinct values flag column can have?
from 1 to 9
can the index work with 1 to 9

INDEX ON flag FOR FLAG = 0 tag FLAG_TAG

thanks.

>How many distinct values flag column can have?
>
>If flag can only have 0 and 1 values(or few distinct values), is not recommended to have an index without good selectivity, because Rushmore will use it even if is not necessary.
>
>Maybe the better solution is to have, if you only need a quick access to records with flag=0, a filtered index with "FOR flag = 0" as filter clause
>

>INDEX ON flag FOR FLAG = 0 tag FLAG_TAG
>

>
>Then
>

>USE newdnc
>set order to TAG_FLAG
>go top
>if not eof()
>    thisform.text4.Value=char2
>    thisform.text7.Value=char3
>    thisform.text6.Value=char4
>    thisform.text8.Value=char5
>    thisform.text5.Value=char6
>else
>    =MESSAGEBOX("not found")
>endif
>set order to 0
><pre>
>
>
>
>>hi all,
>>
>>i have table with more than 10,000 records, at network(many users).
>>
>>i need to found record with flag=0,to get all information at myform
>>
>>i useto locate to finde it as under,maybe somthing else faster.
>>any idea
>><pre>
>>USE newdnc
>>LOCATE FOR flag=0
>>if found()
>>    thisform.text4.Value=char2
>>    thisform.text7.Value=char3
>>    thisform.text6.Value=char4
>>    thisform.text8.Value=char5
>>    thisform.text5.Value=char6
>>else
>>    =MESSAGEBOX("not found")
>>endif
>>

>>thanks.
>>m.qasem