{"id":2701,"date":"2021-08-17T06:00:00","date_gmt":"2021-08-17T00:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=2701"},"modified":"2021-08-15T18:41:13","modified_gmt":"2021-08-15T13:11:13","slug":"mysql-index","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-index\/","title":{"rendered":"MySQL Index"},"content":{"rendered":"\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 \u090f\u0915 Techinque \u0939\u0948\u0902 \u091c\u093f\u0938\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0939\u092e \u091c\u093f\u0938 Record \u0915\u094b Access \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938 \u092a\u0930 \u0915\u092e \u0938\u0947 \u0915\u092e Step \u092e\u0947\u0902 \u092a\u0939\u0941\u0901\u091a \u0938\u0915\u0947\u0964 \u092f\u093e\u0928\u093f \u0915\u0940 \u092f\u0926\u093f \u0939\u092e\u0947\u0902 \u0915\u094b\u0908 \u092d\u0940 Record Search \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0924\u094b \u0935\u0939 \u092c\u0939\u0941\u0924 \u091c\u0932\u094d\u0926\u0940 \u0939\u092e\u0947\u0902 \u092e\u093f\u0932 \u0938\u0915\u0947 \u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u091c\u092c database Table \u092e\u0947\u0902 Record \u0915\u0940 \u0938\u0902\u0916\u094d\u092f\u093e \u092c\u0939\u0941\u0924 \u0905\u0927\u093f\u0915 \u0939\u094b \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0914\u0930 \u0924\u092c \u092f\u0926\u093f \u0915\u093f\u0938 Record \u0915\u094b Search \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b Sequential Search \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0938\u092e\u092f \u0932\u0917\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f Record \u0915\u093f\u0938 \u092d\u0940 Indexing Technique \u0938\u0947 Sort \u0939\u094b\u0902\u0917\u0947 \u0924\u094b Database \u0926\u094d\u0935\u093e\u0930 \u0909\u0928\u094d\u0939\u0947\u0902 Search \u0915\u0930\u0928\u0947 \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0939\u0940 \u0915\u092e \u0938\u092e\u092f \u0932\u0917\u0947\u0917\u093e \u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0905\u0932\u0917 \u0905\u0932\u0917 \u0924\u0930\u0939 \u090f\u0915 Index \u092e\u093f\u0932 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0932\u0947\u0915\u093f\u0928 \u092f\u0926\u093f \u0906\u092a\u0915\u094b \u0938\u0930\u0932 \u092d\u093e\u0937\u093e \u092e\u0947\u0902 MySQL \u0915\u0947 Index \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0938\u092e\u091d\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e Index \u0915\u094b \u0926\u094b \u092d\u093e\u0917\u094b \u092e\u0947\u0902 Divide \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Clustered Index<\/strong><ul><li><strong>Primary Index<\/strong><\/li><li><strong>Unique Index or Unique<\/strong> ( \u092f\u0926\u093f Table \u092e\u0947\u0902 \u0915\u094b\u0908 \u092d\u0940 Primary \u0915\u0947 Define \u0928\u0939\u0940\u0902 \u0915\u0940 \u0939\u094b \u0924\u094b \u092f\u0939 Index Storage Engine \u0926\u094d\u0935\u093e\u0930\u093e \u092c\u0928\u093e \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948 \u0907\u0938\u0932\u093f\u090f \u0909\u0938 \u0938\u092e\u092f \u092f\u0939 Clustered Index \u0915\u093e \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0914\u0930 \u092f\u0926\u093f Primary Key \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u092f\u0926\u093f \u0939\u092e Unique \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 Non-Clustered Index \u092c\u0928 \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964)<\/li><\/ul><\/li><li><strong>Non Clustered Index<\/strong><ul><li>Simple Index or Index<\/li><li>Spatial Index (like Geo Columns)<\/li><\/ul><ul><li>FullText index (For Char, Varchar, Text)<\/li><\/ul><\/li><\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0906\u0907\u092f\u0947 \u0905\u092c \u090f\u0915 \u090f\u0915 \u0915\u0930 \u0906\u092a\u0915\u094b \u0938\u092d\u0940 \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Clustered Index<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0910\u0938\u0947 index \u091c\u094b \u0915\u0940 \u090f\u0915 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939 \u092e\u093e\u0928\u0947 \u0915\u0947 Same Table \u092e\u0947\u0902 \u0939\u0940 Store \u0939\u094b \u091c\u093e\u0924\u0947 \u0939\u0948 \u0914\u0930 Physically \u092d\u0940 \u0921\u093e\u091f\u093e \u0915\u094b \u0909\u0938\u0915\u0947 Order Wise \u0939\u0940 Sort \u0915\u0930 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902, \u092f\u093e\u0928\u093f \u0910\u0938\u0947 index \u090f\u0915 \u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0928\u0939\u0940\u0902 \u092c\u0928\u093e \u0938\u0915\u0924\u0947\u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><strong>Primary Key index \u0907\u0938\u0940 \u0915\u093e \u092d\u093e\u0917 \u0939\u0948\u0902 \u0964<\/strong><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0928\u093f\u091a\u0947 Screen Shot \u092e\u0947\u0902 \u0906\u092a \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0915\u093f\u0938 \u0924\u0930\u0939 Cluster Index main table \u092e\u0947\u0902 \u0939\u0940 Sort \u0939\u094b \u0915\u0930 Store \u0930\u0939\u0924\u093e \u0939\u0948\u0902 \u0914\u0930 \u092f\u0926\u093f \u0906\u092a \u092c\u093e\u0926 \u092e\u0947\u0902 \u092d\u0940 \u0915\u094b\u0908 Entry \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0909\u0938\u0947 \u0909\u0938 Location \u092a\u0930 Set \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u092f\u093e\u0928\u093f \u0915\u0940 \u092f\u0939 Order Permanent \u0939\u0940 Store \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0902 Table \u092e\u0947\u0902 \u0964<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"614\" height=\"362\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Clustered-Index-Non-Clustered-Index.jpg?resize=614%2C362&#038;ssl=1\" alt=\"Clustered Index &amp; Non Clustered Index\" class=\"wp-image-2753\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Clustered-Index-Non-Clustered-Index.jpg?w=614&amp;ssl=1 614w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Clustered-Index-Non-Clustered-Index.jpg?resize=300%2C177&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Clustered-Index-Non-Clustered-Index.jpg?resize=460%2C270&amp;ssl=1 460w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/Clustered-Index-Non-Clustered-Index.jpg?resize=465%2C274&amp;ssl=1 465w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Non-Clustered Index<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0907\u0938 \u0924\u0930\u0939 \u0915\u0947 Index \u090f\u0915 \u0905\u0932\u0917 \u091c\u0917\u0939 Store \u0930\u0939\u0924\u0947 \u0939\u0948, \u0914\u0930 Main Table \u091c\u093f\u0938 \u092a\u0930 \u0932\u093f\u0916\u0947 \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 Data \u0915\u094b \u092a\u0949\u0907\u0902\u091f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 , \u0907\u0938\u0932\u093f\u090f \u0907\u0938 \u0924\u0930\u0939 \u090f\u0915 Index \u090f\u0915 Table \u092a\u0930 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">MySQL \u0915\u0947 Primary \u0915\u0947 \u0905\u0932\u093e\u0935\u093e \u0905\u0928\u094d\u092f \u0938\u092d\u0940 Index non-Cluster \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0939\u0940 \u0939\u0948\u0902 \u0964 \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Screen Shot \u092e\u0947\u0902 \u0906\u092a \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0915\u093f\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 non-cluster \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0928\u0947 \u0905\u092a\u0928\u0947 \u0932\u093f\u092f\u0947 \u090f\u0915 \u0905\u0932\u0917 Table \u092c\u0928\u093e\u0908 \u0939\u0948\u0902 \u0914\u0930 \u0909\u0938\u092e\u0947 Data \u0915\u094b Sorting order \u092e\u0947\u0902 \u0930\u0916 \u0915\u0930 Main Table \u0915\u094b Point \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964<br><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Index  <\/li><li>Unique<\/li><li>Spatial <\/li><li>FullText <\/li><\/ul>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"> <\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Primary Index<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0907\u0938 \u0924\u0930\u0939 \u0915\u0947 Index \u0915\u094b Cluster Index \u092c\u094b\u0932\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u092f\u0939 Index Unique \u0924\u094b \u0939\u094b\u0924\u0947 \u0939\u0940 \u0939\u0948\u0902 \u0938\u093e\u0925 \u092e\u0947\u0902 Null Value \u0915\u094b Accept \u092d\u0940 \u0928\u0939\u0940\u0902 \u0915\u0930\u0924\u0947, \u091c\u092c \u092d\u0940 \u0915\u093f\u0938\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 Data \u0915\u094b Update \u0914\u0930 Delete \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0907\u0928\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u092c \u092d\u0940 \u0915\u093f\u0938\u0940 \u092d\u0940 Table \u092e\u0947\u0902 Primary Key \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u092f\u0939 Index \u0905\u092a\u0928\u0947 \u0906\u092a \u0939\u0940 \u092c\u0928 \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>\u0915\u094b\u0908 \u092d\u0940 \u091f\u0947\u092c\u0932 \u092c\u0928\u093e\u092f\u0947 \u0909\u0938\u092e\u0947 \u0939\u092e\u0947\u0936\u093e Primary Key \u092c\u0928\u093e\u0928\u093e \u0939\u0940 \u091a\u093e\u0939\u093f\u090f \u0964<\/li><li>\u0915\u094b\u0908 \u092d\u0940 Record \u0915\u094b Update \u0914\u0930 Delete \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Primary Key \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0964<\/li><li><\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\/\/Using Table ADD\nALTER TABLE &lt;TableName> ADD PRIMARY KEY (ColumnName);\n\n\n\/\/Using Table DROP\nALTER TABLE &lt;TableName> DROP PRIMARY KEY;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Unique Index Or Unique<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 \u092d\u0940 Non-Cluster Index \u0939\u0948\u0902 , \u092f\u0939 \u092d\u0940 Simple Index \u091c\u0948\u0938\u093e \u0939\u0940 \u0939\u0948\u0902 \u0907\u0938\u092e\u0947\u0902 \u092f\u0939 \u0935\u093f\u0936\u0947\u0937\u0924\u093e \u0939\u0948\u0902 \u0915\u0940 \u092f\u0939 Duplicate Record accept \u0928\u0939\u0940\u0902 \u0915\u0930\u0924\u093e \u0939\u0948\u0902, \u0907\u0938\u0940 \u0915\u093e\u0930\u0923 \u0907\u0938\u0947 Unique Index \u092d\u0940 \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0939 Null Accept \u0915\u0930 \u0932\u0947\u0924\u093e \u0939\u0948\u0902 Primary Index \u0914\u0930 Unique Index \u092e\u0947\u0902 \u092f\u0939 \u092d\u0940 \u090f\u0915 Difference \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Primary \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u090f\u0915 Index \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u092d\u0940 \u0915\u093f\u092f\u093e \u091c\u093e \u0938\u0915\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>\u092f\u0939 Null Value \u0915\u094b Accept \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\/\/Using Table Add\nALTER TABLE &lt;TableName&gt; ADD UNIQUE &lt;IndexName&gt; (&lt;ColumnName&gt;) ;\n\n\/\/Using Table Drop\nALTER TABLE &lt;TableName&gt; DROP INDEX &lt;IndexName&gt;;\n\n\/\/Using Index Create\nCREATE UNIQUE INDEX &lt;IndexName&gt; ON &lt;TableName&gt; (&lt;ColumnName&gt;);\n\n\/\/Using Index Drop\nDROP INDEX &lt;IndexName&gt; ON &lt;TableName&gt;;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Unique Index Or Unique<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 \u092d\u0940 Non-Cluster Index \u0939\u0948\u0902 , \u092f\u0939 \u092d\u0940 Simple Index \u091c\u0948\u0938\u093e \u0939\u0940 \u0939\u0948\u0902 \u0907\u0938\u092e\u0947\u0902 \u092f\u0939 \u0935\u093f\u0936\u0947\u0937\u0924\u093e \u0939\u0948\u0902 \u0915\u0940 \u092f\u0939 Duplicate Record accept \u0928\u0939\u0940\u0902 \u0915\u0930\u0924\u093e \u0939\u0948\u0902, \u0907\u0938\u0940 \u0915\u093e\u0930\u0923 \u0907\u0938\u0947 Unique Index \u092d\u0940 \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0939 Null Accept \u0915\u0930 \u0932\u0947\u0924\u093e \u0939\u0948\u0902 Primary Index \u0914\u0930 Unique Index \u092e\u0947\u0902 \u092f\u0939 \u092d\u0940 \u090f\u0915 Difference \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Primary \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u090f\u0915 Index \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u092d\u0940 \u0915\u093f\u092f\u093e \u091c\u093e \u0938\u0915\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><li>\u092f\u0939 Null Value \u0915\u094b Accept \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\/\/Using Table Add\nALTER TABLE &lt;TableName&gt; ADD UNIQUE &lt;IndexName&gt; (&lt;ColumnName&gt;) ;\n\n\/\/Using Table Drop\nALTER TABLE &lt;TableName&gt; DROP INDEX &lt;IndexName&gt;;\n\n\/\/Using Index Create\nCREATE UNIQUE INDEX &lt;IndexName&gt; ON &lt;TableName&gt; (&lt;ColumnName&gt;);\n\n\/\/Using Index Drop\nDROP INDEX &lt;IndexName&gt; ON &lt;TableName&gt;;\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Simple Index or Index<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 Non-Cluster Index \u0939\u0948\u0902 , \u091c\u094b \u0915\u0940 Table \u092e\u0947\u0902 Store \u0928 \u0939\u094b \u0915\u0930 \u090f\u0915 \u0905\u0932\u0917 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 store \u0939\u094b \u0915\u0930 Main Table \u0915\u0940 Records \u0915\u094b \u092a\u0949\u0907\u0902\u091f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964 \u0905\u0932\u0917 \u091c\u0917\u0939 Store \u0939\u094b\u0928\u0947 \u0915\u0947 \u0915\u0930\u0928\u093e \u0939\u092e \u090f\u0915 Table \u092a\u0930 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Index \u0932\u093f\u0916 \u092a\u093e\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u0915\u093f\u0938\u0940 Table \u0915\u0940 \u092f\u0926\u093f \u0915\u094b\u0908 \u0915\u0949\u0932\u092e \u0910\u0938\u093e \u0939\u0940 \u091c\u093f\u0938 \u092a\u0930 \u0939\u092e\u0947\u0902 Search \u0915\u0930\u0928\u093e \u0939\u094b \u092f\u093e \u0939\u092e\u0947\u0902 \u0905\u0927\u093f\u0915\u0924\u0930 \u0909\u0938 Filed \u0938\u0947 Query \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u0940 \u0939\u0948 \u0924\u094b \u0939\u092e \u0907\u0938 \u0924\u0930\u0939 \u0915\u0947 Index \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>\u0907\u0938 \u0924\u0930\u0939 \u0915\u0947 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u092d\u0940 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><li>\u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Column \u092a\u0930 \u090f\u0915 \u0938\u093e\u0925 \u0907\u0938 \u0924\u0930\u0939 \u0915\u0947 Index \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\/\/Using Table ADD\nALTER TABLE &lt;TableName> ADD INDEX &lt;IndexName> (&lt;ColumnName>) ;\n\n\n\/\/Using Table DROP\nALTER TABLE &lt;TableName> DROP INDEX &lt;IndexName>;\n\n\n\/\/Using Index\nCREATE INDEX &lt;IndexName> ON &lt;TableName> (&lt;ColumnName>);\nDROP INDEX &lt;IndexName> ON &lt;TableName>;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"> Spatial Index <\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 index Geo Location \u0915\u094b \u0927\u094d\u092f\u093e\u0928 \u092e\u0947\u0902 \u0930\u0916\u0915\u0930 \u092c\u0928\u093e\u092f\u0947 \u0917\u090f \u0939\u0948\u0902 \u0907\u0938 \u092a\u0930 R-Tree \u092f\u093e Quad Technique \u0938\u0947 searching \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964 Geo Location \u0915\u094b \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 Arrange \u0915\u0930 \u0930\u0916\u0928\u0947 \u092e\u0947\u0902 Point \u0924\u0915 \u092a\u0939\u0941\u0902\u091a\u0928\u0947 \u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0939\u0940 \u0906\u0938\u093e\u0928\u0940 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u093f\u0924\u0928\u0947 \u092d\u0940 Spatial Column \u0939\u0948\u0902 \u0909\u0928 \u0938\u092d\u0940 \u092a\u0930 \u0939\u092e Spatial Index \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 .<\/li><li>\u0907\u0938 Technique \u0938\u0947 Gio \u0938\u0947 Related Data \u0915\u0940 Searching Speed Increase \u0939\u094b \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0964<\/li><li>\u0907\u0938 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0915\u094b Special \u0939\u0940 Spatial Field \u0915\u0947 \u0932\u093f\u090f Design \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964<\/li><\/ul>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\/\/Using Table\nALTER TABLE &lt;TableName> ADD SPATIAL &lt;IndexName> (&lt;ColumnName>) ;\n\n\n\/\/Using Table Drop\nALTER TABLE &lt;TableName> DROP INDEX &lt;IndexName>;\n\n\n\/\/Using Index Create\nCREATE SPATIAL INDEX &lt;IndexName> ON &lt;TableName> (&lt;ColumnName>);\n\n\n\/\/Using Index Drop\nDROP INDEX &lt;IndexName> ON &lt;TableName>;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">FullText Index<\/h2>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 \u092d\u0940 \u090f\u0915 Non-cluster index \u0939\u0948 \u091c\u094b \u0915\u0940 \u092f\u0939 Char, Varchar,  Text \u0906\u0926\u093f Type \u0915\u0940 Field \u092a\u0930 \u0939\u0940 Index \u092c\u0928\u093e\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 , \u092f\u0939 index \u0905\u0932\u0917 \u0905\u0932\u0917 Word \u0915\u094b Store \u0915\u0930 \u0909\u0928\u094d\u0939\u0947\u0902 Ranking Provide \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0914\u0930 \u092b\u093f\u0930 \u091c\u092c \u0939\u0948\u0902 \u0909\u0938\u0947 MATCH&#8230;AGAINST Command \u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0906\u092a Search \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 , \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 Search \u0915\u0930\u0928\u0947 \u0938\u0947 Result \u092c\u0939\u0941\u0924 \u0939\u0940 \u091c\u0932\u094d\u0926\u0940 \u0906\u0924\u093e \u0939\u0948 \u0964<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Character Type \u0915\u0940 Field \u0915\u0947 \u0932\u093f\u090f Special Design \u0915\u093f\u092f\u093e \u0917\u092f\u093e \u0939\u0948\u0902 \u0964<\/li><li>Text Field \u0915\u0940 Searching \u0915\u094b \u092c\u0939\u0941\u0924 \u0939\u0940 Fast \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0902<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">\/\/Using Table Add\nALTER TABLE &lt;TableName> ADD FULLTEXT &lt;IndexName> (&lt;ColumnName>) ;\n\n\/\/Using Table Drop\nALTER TABLE &lt;TableName> DROP INDEX &lt;IndexName>;\n\n\/\/Using Index\nCREATE FULLTEXT INDEX &lt;IndexName> ON &lt;TableName> (&lt;ColumnName>);\n\n\/\/Using Index Drop\nDROP INDEX &lt;IndexName> ON &lt;TableName>;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>Name<\/strong><\/td><td><strong>Type<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>NULL<\/strong><\/td><td class=\"has-text-align-center\" data-align=\"center\"><strong>Duplicate<\/strong><\/td><td><strong>Apply on Data Type<\/strong><\/td><\/tr><tr><td>PRIMARY<\/td><td>CLUSTERED<\/td><td class=\"has-text-align-center\" data-align=\"center\">No<\/td><td class=\"has-text-align-center\" data-align=\"center\">No<\/td><td>ANY<\/td><\/tr><tr><td>UNIQUE<\/td><td>CLUSTERED \/ NON-CLUS.<\/td><td class=\"has-text-align-center\" data-align=\"center\">Yes\/No<\/td><td class=\"has-text-align-center\" data-align=\"center\">No<\/td><td>ANY<\/td><\/tr><tr><td>INDEX<\/td><td>NON-CLUSTER<\/td><td class=\"has-text-align-center\" data-align=\"center\">Yes <\/td><td class=\"has-text-align-center\" data-align=\"center\">Yes <\/td><td>ANY<\/td><\/tr><tr><td>SPATIAL<\/td><td>NON-CLUSTER  <\/td><td class=\"has-text-align-center\" data-align=\"center\">Yes <\/td><td class=\"has-text-align-center\" data-align=\"center\">Yes <\/td><td>SPATIAL like Geo Location<\/td><\/tr><tr><td>FULLTEXT<\/td><td>NON-CLUSTER   <\/td><td class=\"has-text-align-center\" data-align=\"center\"> Yes <\/td><td class=\"has-text-align-center\" data-align=\"center\">Yes <\/td><td>CHAR, VARCHAR, TEXT<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Clustered Index Primary Index Unique Index or Unique ( \u092f\u0926\u093f Table \u092e\u0947\u0902 \u0915\u094b\u0908 \u092d\u0940 Primary \u0915\u0947 Define \u0928\u0939\u0940\u0902 \u0915\u0940 \u0939\u094b \u0924\u094b \u092f\u0939 Index Storage Engine \u0926\u094d\u0935\u093e\u0930\u093e \u092c\u0928\u093e \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948 \u0907\u0938\u0932\u093f\u090f \u0909\u0938 \u0938\u092e\u092f \u092f\u0939 Clustered Index \u0915\u093e \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0914\u0930 \u092f\u0926\u093f Primary Key \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u092f\u0926\u093f \u0939\u092e Unique \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u092f\u0939 Non-Clustered [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2750,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-2701","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/mysql-index.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=2701"}],"version-history":[{"count":54,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2701\/revisions"}],"predecessor-version":[{"id":2758,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2701\/revisions\/2758"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/2750"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=2701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=2701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=2701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}