adspace


What is excution Plan in sql server

Answer Posted / cla

A query execution plan outlines how the SQL Server query optimizer actually ran or possibly run a query

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you index views?

953


What are the different subsets of sql?

1648


Can one drop a column from a table?

1088


What is a scheduled job or what is a scheduled task?

1037


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2293


Equi join and non equi join is possible with sql server?

1134


What are different types of constraints?

1000


What is subquery? Explain the properties of a subquery?

1058


What is in place upgrade in sql server?

1125


Explain system functions or built-in functions? What are different types of system functions?

1065


What are wait types?

1248


What is self contained sub query?

1139


How to convert character strings into numeric values?

1189


Why should you use or avoid select * statements?

1108


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1298