Q&A BY TAG 'query plan'

You must sign in to ask a question. If you do not have an account, you can register here

Extracting query with the hardcoded values not parameterized.
answered 29-08-2018 05:33:44 -0400

Hi, Currently we are running a query which has a lot of hard coded values. The query in its execution plan shows up like below Select as column1, as column2 from table; parameters = [<parameter1>, <parameter2>] How can I extract a que...

Answers: 1

query plan Parameterize Query Execution plans Parameter

WHERE Clause in query
answered 10-01-2018 14:12:41 -0500

I have created dervied view's using Baseview views and query also has an where clause at the end on one the Base view. When I run the new derived view the where condition is executed at the end. I dont see this helping peformance. please let me know, I...

Answers: 1

query plan Sql performance WHERE CONDITIONS