Hi,, I am looking fo a query optimizer utility. I 've heard of one running on Linux. This is how it works: Execute your SQL Query - via the Linux Utility - the query is optimize by the urtility and results rendered to the client, i cant remenber the name of this utility, Does someone know about any other utility of the same kind???? Thanks AKTHAR DILMOHAMUD 65 BENARES ST PORT LOUIS MAURITIUS
Are you looking for a tool to run against SQL Server or some other RDBMS? -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
Hi,<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />I am looking fo a query optimizer utility. I 've heard of one running on Linux. This is how it works:<br />Execute your SQL Query - via the Linux Utility - the query is optimize by the urtility and results rendered to the client, i cant remenber the name of this utility,<br /><br />Does someone know about any other utility of the same kind????<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />AFAIK their's no tool that is used to direct connect to MS SQL from Linux but their are odbc and jdbc drivers are available that can be use to connect with , here are some references :<br /><br /><a href='http://ccm.redhat.com/bboard-archive/webdb/00067l.html' target='_blank' title='http://ccm.redhat.com/bboard-archive/webdb/00067l.html'<a target="_blank" href=http://ccm.redhat.com/bboard-archive/webdb/00067l.html>http://ccm.redhat.com/bboard-archive/webdb/00067l.html</a></a><br /><a href='http://www.faqts.com/knowledge_base/view.phtml/aid/402' target='_blank' title='http://www.faqts.com/knowledge_base/view.phtml/aid/402'<a target="_blank" href=http://www.faqts.com/knowledge_base/view.phtml/aid/402>http://www.faqts.com/knowledge_base/view.phtml/aid/402</a></a><br /><a href='http://www.linuxjournal.com/article/6636' target='_blank' title='http://www.linuxjournal.com/article/6636'<a target="_blank" href=http://www.linuxjournal.com/article/6636>http://www.linuxjournal.com/article/6636</a></a><br /><br />[<img src='/community/emoticons/emotion-1.gif' alt='' />]<br />Regards <br /><br /><br /><br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami<br />
any other tool even on Windows is not a problem , for SQL SERVER AKTHAR DILMOHAMUD 65 BENARES ST PORT LOUIS MAURITIUS
I don't think you will find a tool that will optimize queries better than the build-in optimizer. What's wrong with Query Analyzer? -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
hi, quote:Originally posted by Akthar any other tool even on Windows is not a problem , for SQL SERVER AKTHAR DILMOHAMUD 65 BENARES ST PORT LOUIS MAURITIUS i didn't understand y you are not using built in QA [?] ? or you need to format query ?! if it is so then search in Third-Party Tool in forum Regards Hemantgiri S. Goswami ghemant@gmail.com "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemant Goswami
hi Frank, no problem with SQL Query Analyzer, i have an application already written which i cant modify, just looking for a tool that can give a better performance of existing queries. AKTHAR DILMOHAMUD 65 BENARES ST PORT LOUIS MAURITIUS
I see. In this case I would probably start with the Index Tuning Wizard. Have a look here:<br /<a target="_blank" href=http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx>http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx</a><br /<a target="_blank" href=http://support.microsoft.com/default.aspx?scid=kb;EN-US;311826>http://support.microsoft.com/default.aspx?scid=kb;EN-US;311826</a><br /<a target="_blank" href=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/itwforsql.asp>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/itwforsql.asp</a><br /><br />It should give you ideas how you can improve performance via indexes. However, if the query itself is poor, no index can fix this. To a certain degree SQL Server is able to semantically optimize queries itself, but it cannot make a "good" query out of a "poor". When you have identified such poor performing queries and are in doubt if they are good or not so good, post them here. [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
