[AccessD] SQL to manipulate indexes

Gustav Brock gustav at cactus.dk
Sun May 4 11:43:18 CDT 2003


Hi Susan

Are you talking about compound indexes? Not sure if these are
"complex" though.

We have two cases: one for adjusting indexes in an existing backend
database and one for building temporary databases from scratch.

In both cases I know how many and which fields are present or needed
of an index. No big deal. The real problem is to add an index to an
existing and populated table as you have to check first if the
recorded values will allow that index to be applied and, if not, how to
handle that situation.

/gustav


> How many of you actually manipulate indexes programmatically on a frequent
> basis? How do you get around the problem of knowing how many arguments
> (field names) to pass for a complex index?



More information about the AccessD mailing list