question

mjkick avatar image
mjkick asked

how to implement algorithims in sql ?

i am going to increase the efficiency of a query? so what should i do? and is there any tool to implement the algorithms in sql??
toolsalgorithm
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This site runs off of votes. Please mark all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that answer.
0 Likes 0 ·
Tim avatar image
Tim answered
That is a fairly loaded question. First you should look at the current efficiency of the query to see that it is structured that it is pulling back the minimal amount of data needed. Ensure that the query is utilizing the proper existing indexes or that there are proper indexes in place to support the query. There are lots of opportunities within the query itself to also optimize in many cases to use joins properly, avoid costly operations etc. If you were able to post the query then myself and others could help determine if you are doing anything less efficient.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank u so much for u r reply,i'll say you clearly,we have to do a project in that so can u explain me?? i'll post the query soon.how can i implement the algorthim??
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
Query tuning is a huge topic. You can't get a simple answer to a general question like that. I'd suggest picking up a copy of my book: [SQL Server 2012 Query Performance Tuning][1]. It's applicable to other versions of SQL Server as well. [1]: http://www.amazon.com/Server-2012-Query-Performance-Tuning/dp/1430242035/ref=sr_1_2?ie=UTF8&qid=1391434189&sr=8-2&keywords=fritchey
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.