Lockley

Hi,

Has anyone run into the problem, when querying the mom tables through access and odbc, of not having the indexes work for some queries ?

Specifically, when I run a query on the CMS table and search for a record using the alt_order field in the where clause, it appears to not use the index that is defined for that field.

Is there a fix for this problem ? or am I missing something ?

A sql example that should be fast, but isn't is something like this:

select order from cms where alt_order = '323771'

or

select order from cms where internetid = 'Yahoo-323771'

Any help you have would be greatly appreciated.

Thanks.

-Lockley Gentes/WorshipMusic.com