1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

Explain how to find the given query is optimised one or not?

Question Posted / arun kumar


Explain how to find the given query is optimised one or not?..

Answer / Manish Himdan

To determine if a SQL query is optimized, you can analyze its execution plan. The execution plan shows the steps that the database engine uses to execute the query and the estimated costs of each step. A well-optimized query should have a low cost for each step and use efficient indexes. You can view the execution plan using tools like SQL Server Management Studio or SQL Profiler.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

What are the Features and disadvantages of dataset

1 Answers   Microsoft,

What are the benefits of ADO.NET?

1 Answers   B-Ways TecnoSoft,

What is the role of clr?

1 Answers  

Which method in OLEDBAdapter is used to populate dataset with records?

1 Answers  

Define different execute methods of ADO.NET command object ?

1 Answers   NA,

How does entity framework work?

1 Answers  

What is ado rdo dao in visual basic?

1 Answers  

what is data Adapter?

26 Answers   CMC, CSS, IBM,

what are the two key events for the sql connection class? explain the differnce between the two.

2 Answers   HCL, NIIT, Zensar,

What providers do you use to connect to oracle database ?

4 Answers   Digital GlobalSoft,

What is ado.net object model?

1 Answers  

What is a dataset?

3 Answers  

For more ADO.NET Interview Questions Click Here
Categories