Can I add more indexes to baan sql server 7 tables
SQL SERVER 7
only indexes on current baan sql server tables are the hash fields
using ms-access to create management reports
some tables like tdsls051 has over 1 million rows and it takes 5 - 6 minutes for a query using this to run on the server
we've got a test baan server, and ran the same query after creating a index for a field used in my WHERE clause... it now runs in under 30 secs
I'd like to add indexes on the production server for this and other tables, but am not sure of its impact, if any, on baan ??