Index Files

Is there a minimum number of records required for indexes to work properly?

Thanks
Dan

Index Files



As soon as you have a record in your db, the index file will work properly.

Scot

<A HREF ="http://www.scotsscripts.com">http://www.scotsscripts.com</A>

Dr. Daniel M. Sweger wrote:
> Is there a minimum number of records required for indexes to work properly?
>
> Thanks
> Dan
>

Index Files



> Is there a minimum number of records required for indexes to work
> properly?
>
Yep: zero.
But if you're having problems, there are a number of reasons your search
may be failing:

1) alias: If you create the index with an alias in the index expression,
the index will only work when the db is opened using that alias. To create
an index which can be used with various aliases, use only "d.fieldname" in
the index expression (the database will have to be the primary database at
the time MvMakeindex is executed

2) MvFIND is case sensitive. If you have alphanumeric index fields, it
pays to use tolower() or toupper() in the index expression and remember to
convert your search term.

3) spaces - make sure you strip any leading spaces off the data for your
character-type key fields before storing it. (ditto for search terms)