about select top 1 null

117320117320 Member Posts: 33
can someone explain to me what is the meaning for SQL query "Select top 1 Null from table A"?

because i run my client monitor and found out all process with sql query "Select top 1 Null from table A" consume a lot of time to run.

is this an issue?if yes how to solve?

Please help. Thank you.

Comments

  • ara3nara3n Member Posts: 9,256
    select Top 1 Null is executed on sql when NAV uses Record.ISEMPTY function.

    You need to check the where clause and make sure you have a good index for it.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
Sign In or Register to comment.