<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Pravin Mishra on Medium]]></title>
        <description><![CDATA[Stories by Pravin Mishra on Medium]]></description>
        <link>https://medium.com/@pravinmishra?source=rss-f954c75c219------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*_Nz7trLrkTGX0R9a.</url>
            <title>Stories by Pravin Mishra on Medium</title>
            <link>https://medium.com/@pravinmishra?source=rss-f954c75c219------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 15:18:04 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@pravinmishra/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[SQL optimization tips]]></title>
            <link>https://medium.com/@pravinmishra/sql-optimization-tips-e1ca808d3df2?source=rss-f954c75c219------2</link>
            <guid isPermaLink="false">https://medium.com/p/e1ca808d3df2</guid>
            <category><![CDATA[database]]></category>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Pravin Mishra]]></dc:creator>
            <pubDate>Wed, 22 Jul 2020 16:29:46 GMT</pubDate>
            <atom:updated>2020-07-22T16:29:46.108Z</atom:updated>
            <content:encoded><![CDATA[<p>If you are using multiple joins to fetch the data and the query is slow, you should check the execution plan of the query by adding ‘EXPLAIN’ in front of the query. For example</p><pre>EXPLAIN SELECT u.name as user_name, c.name as company_name from users u left join company c on u.company_id = c.id</pre><p>This will give you the execution plan of the query as shown below</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/f70be231b661d39d2ba6abc754495608/href">https://medium.com/media/f70be231b661d39d2ba6abc754495608/href</a></iframe><p>One of the columns that you should look for in this table is ‘type’.It says how the tables are joined. The value ‘eq_ref’ is best and ‘all’ is worst. The presence of ‘all’ in the ‘type’ column denotes the lack of proper indexing in the corresponding table. You should then add a proper index to the table and the query performance will improve</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e1ca808d3df2" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>