{"id":23196,"date":"2021-03-26T20:15:33","date_gmt":"2021-03-27T00:15:33","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/how-to-optimize-query-response-time-root-by-sayed-ahmed\/"},"modified":"2021-03-26T20:15:33","modified_gmt":"2021-03-27T00:15:33","slug":"how-to-optimize-query-response-time-root-by-sayed-ahmed","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=23196","title":{"rendered":"How to optimize query response time? #Root #By Sayed Ahmed"},"content":{"rendered":"<ul>\n<li>Check that only the required columns are selected [in select statements]<\/li>\n<li>Check that the right types of joins are used<\/li>\n<li>Check that if re-ordering the joins will help or not<\/li>\n<li>Check the indexes of the tables [is indexing done on the right columns]<\/li>\n<li>Check that in joins you used the indexed columns in the join condition<\/li>\n<li>Check that the operating system is configured for optimum performance [for SQL Server]<\/li>\n<li>Use concepts like Scaling Up and Scaling Out to increase the overall performance of queries\/SQL Server<\/li>\n<li>Use Dynamic Management Views to analyze the query performance\/(query execution plans)<\/li>\n<li>Use hints to skip default query execution plan to introduce your plan for quick response. Use hints on join types or also for table index selection<\/li>\n<li>Check that the system and the network are appropriately configured and there are no issues that can cause the performance penalty<\/li>\n<li>Tools that may help in the analysis and improvement: DBCC Commands, Dynamic Management Views, SQL Server Profiler, SQL Server Management Studio, System Stored Procedures, and SQL Trace<\/li>\n<li><a href=\"http:\/\/justetc.net\/knowledge\/displayArticle.php?table=Articles&amp;articleID=711\">Check these articles for more information<\/a><\/li>\n<\/ul>\n<p> From: http:\/\/sitestree.com\/?p=3659<br \/> Categories:Root, By Sayed Ahmed<br \/>Tags:<br \/> Post Data:2016-09-15 14:19:59<\/p>\n<p>\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a><br \/>\n\t\tIn Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a><br \/>\n\t\t<a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a><br \/>\n\t\t8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a><br \/>\n\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\tMedium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Check that only the required columns are selected [in select statements] Check that the right types of joins are used Check that if re-ordering the joins will help or not Check the indexes of the tables [is indexing done on the right columns] Check that in joins you used the indexed columns in the join &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=23196\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-23196","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69270,"url":"http:\/\/bangla.sitestree.com\/?p=69270","url_meta":{"origin":23196,"position":0},"title":"How to optimize query response time? #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Check that only the required columns are selected [in select statements] Check that the right types of joins are used Check that if re-ordering the joins will help or not Check the indexes of the tables [is indexing done on the right columns] Check that in joins you used the\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69256,"url":"http:\/\/bangla.sitestree.com\/?p=69256","url_meta":{"origin":23196,"position":1},"title":"SQL Server Hints #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"SQL Server Hints ---------------- What are hints? Simply to influence query execution plans to retrieve data faster. syscacheobjects ---------------- SQL server after compiling a query creates the execution plan and keeps it on syscacheobjects object. You can query the object to see the existing query plans as follows: select *\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69272,"url":"http:\/\/bangla.sitestree.com\/?p=69272","url_meta":{"origin":23196,"position":2},"title":"SQL Server Short-notes at JustEtc #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Query Optimization How to optimize query response time? SQL Server How to optimize SQL Server Cursors What are cursors? SQL Server Hints Scalability: SQL Server 2005 Scaling Out Dynamic Management Views SQL Server Database System Tuning SQL Server: Index SQL Server : Backups From: http:\/\/sitestree.com\/?p=5221 Categories:38Tags: Post Data:2012-10-04 19:57:27 Shop\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69262,"url":"http:\/\/bangla.sitestree.com\/?p=69262","url_meta":{"origin":23196,"position":3},"title":"Dynamic Management Views #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"Dynamic Management Views provide ways to analyze database performance and to find the cause behind bad-performing SQL server databases\/instances. Bad performance can be due to: poor design, insufficient memory, poorly configured system, disk bottlenecks, poorly written queries and many othersPreviously Windows System Monitor(perfmon.exe) and SQL server profiler were used to\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69274,"url":"http:\/\/bangla.sitestree.com\/?p=69274","url_meta":{"origin":23196,"position":4},"title":"SQL Server Short-notes at JustETC #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"How to optimize query response time? How to optimize SQL Server Cursors What are cursors? SQL Server Hints Scalability: SQL Server 2005 Scaling Out Dynamic Management Views SQL Server Database System Tuning SQL Server: Index SQL Server : Backups SQL Server Short-notes at JustEtc SQL Server Short-notes at JustEtc From:\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":67450,"url":"http:\/\/bangla.sitestree.com\/?p=67450","url_meta":{"origin":23196,"position":5},"title":"Hibernate: Basic Concepts #Java Short Notes","author":"Author-Check- Article-or-Video","date":"July 22, 2021","format":false,"excerpt":"Hibernate Object Relational Mapping Software ORM qualities: Pure relational, Light object mapping, Medium object mapping, Full object mapping ORM Metadata: ORM metadata provides support for mapping between classes and tables, properties and columns, associations and foreign keys, Java types and SQL types. Full Object Mapping: Supports advanced object modeling: composition,\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/23196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23196"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/23196\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23196"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}