key on navision versus index on SQL

117320

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

DenSter

The key that is specified in the NAV client will turn into the ORDER BY clause in the SQL query. You can't really 'tune queries' in NAV. You can modify the design of the objects, and manipulate the way that data is retrieved, but you can't really directly change the actual query itself. Check out Waldo's blog, he wrote a very interesting article about how this works. He's given us a nice overview of his work for 2008: http://dynamicsuser.net/blogs/waldo/arc ... -2008.aspx.