I was wondering if anyone knew of any hazards to adding a SQL Server index to a Baan table. I do a lot of reporting through SQL stored procedures, and would like to optimize the tables for reporting. Obviously I do not want to damage any Baan tables. Any info would be greatly appreciated.

Thanks.

adding indexes directly in the database is common in Oracle database (level 2). there should not be any problem with Ms-SQL (level 1). Just be carrefull with the name of the index : do NOT use one that look like the baan's ones : it could be delivred by Baan within a patch/upgrade.

etienne,

Thanks for the response. I will try it against a table in our test company, and go from there.

Thanks again,

Vince

.. as long as you you don't forget to recreate the index every time you recreate the table (e.g. reorganize tables or doing a convert to runtime).

Kind regards,
Dick

Thanks Dick.

one other option is that sql server 2000 enterprise edition allows you to add an index to a view