about select top 1 null

117320

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.

ara3n

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.