Hello,
Does anyone know if it is possible to add an index in sqlserver to a combination of standard epicor fields and ud fields?
cheers,
John
In Epicor, SQL tables will be different for Base and UD Columns.
Try to put an index on Views which has both tables base and UD to retrieve data.
Hi Fakhruddin,
Thanks for you reply.
I see that in sql server it is not possible to add an index (the ‘New Index’ option is disabled).
Would that mean that I would have to define a new view (a ‘copy’ of the Epicor view) and then add an index to it?
John