I'm using navision 4.0 sp3 and sql server 2005. if i set a key in navision does it mean i set an index on sql server 2005? I create a form to retrieve all value from table,I set proper key,the result is fast,but when I create a query and run it under sql query, why when run the query take time longer than if i run object in navision?do i must set an index for tuning my query?
Please help
0
Comments
RIS Plus, LLC