API tools faq
paste
Advertisement
ajithkgshk

Indexes

ajithkgshk
Jul 23rd, 2023 (edited)
121
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.01 KB | None | 0 0
raw download clone embed print report
  1. MariaDB [productsdb]> show indexes from products;
  2. +----------+------------+-------------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
  3. | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
  4. +----------+------------+-------------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
  5. | products | 0 | PRIMARY | 1 | id | A | 2420403 | NULL | NULL | | BTREE | | | NO |
  6. | products | 1 | index_products_on_name | 1 | name | A | 806801 | NULL | NULL | YES | BTREE | | | NO |
  7. | products | 1 | index_products_on_id | 1 | id | A | 2420403 | NULL | NULL | | BTREE | | | NO |
  8. | products | 1 | index_products_on_part_number | 1 | part_number | A | 2420403 | NULL | NULL | YES | BTREE | | | NO |
  9. | products | 1 | index_products_on_manufacturer | 1 | manufacturer | A | 1382 | NULL | NULL | YES | BTREE | | | NO |
  10. | products | 1 | index_products_on_ctyea_part_number | 1 | ctyea_part_number | A | 2420403 | NULL | NULL | YES | BTREE | | | NO |
  11. | products | 1 | index_products_on_main_category_id | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  12. | products | 1 | index_products_on_sub_category_id | 1 | sub_category_id | A | 699 | NULL | NULL | YES | BTREE | | | NO |
  13. | products | 1 | abcd1index | 1 | main_category_id | A | 3805 | NULL | NULL | YES | BTREE | | | NO |
  14. | products | 1 | abcd1index | 2 | sub_category_id | A | 9643 | NULL | NULL | YES | BTREE | | | NO |
  15. | products | 1 | abcd1index | 3 | attr_1 | A | 63694 | NULL | NULL | YES | BTREE | | | NO |
  16. | products | 1 | abcd1index | 4 | attr_2 | A | 134466 | NULL | NULL | YES | BTREE | | | NO |
  17. | products | 1 | abcd1index | 5 | attr_3 | A | 220036 | NULL | NULL | YES | BTREE | | | NO |
  18. | products | 1 | abcd1index | 6 | attr_4 | A | 302550 | NULL | NULL | YES | BTREE | | | NO |
  19. | products | 1 | abcd2index | 1 | main_category_id | A | 2988 | NULL | NULL | YES | BTREE | | | NO |
  20. | products | 1 | abcd2index | 2 | sub_category_id | A | 7356 | NULL | NULL | YES | BTREE | | | NO |
  21. | products | 1 | abcd2index | 3 | attr_5 | A | 23499 | NULL | NULL | YES | BTREE | | | NO |
  22. | products | 1 | abcd2index | 4 | attr_6 | A | 100850 | NULL | NULL | YES | BTREE | | | NO |
  23. | products | 1 | abcd2index | 5 | attr_7 | A | 161360 | NULL | NULL | YES | BTREE | | | NO |
  24. | products | 1 | abcd2index | 6 | attr_8 | A | 110018 | NULL | NULL | YES | BTREE | | | NO |
  25. | products | 1 | abcd3index | 1 | main_category_id | A | 33 | NULL | NULL | YES | BTREE | | | NO |
  26. | products | 1 | abcd3index | 2 | sub_category_id | A | 582 | NULL | NULL | YES | BTREE | | | NO |
  27. | products | 1 | abcd3index | 3 | attr_9 | A | 4424 | NULL | NULL | YES | BTREE | | | NO |
  28. | products | 1 | abcd3index | 4 | attr_10 | A | 19839 | NULL | NULL | YES | BTREE | | | NO |
  29. | products | 1 | abcd3index | 5 | attr_11 | A | 46546 | NULL | NULL | YES | BTREE | | | NO |
  30. | products | 1 | abcd3index | 6 | attr_12 | A | 37818 | NULL | NULL | YES | BTREE | | | NO |
  31. | products | 1 | abcd4index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  32. | products | 1 | abcd4index | 2 | sub_category_id | A | 616 | NULL | NULL | YES | BTREE | | | NO |
  33. | products | 1 | abcd4index | 3 | attr_13 | A | 5095 | NULL | NULL | YES | BTREE | | | NO |
  34. | products | 1 | abcd4index | 4 | attr_14 | A | 6471 | NULL | NULL | YES | BTREE | | | NO |
  35. | products | 1 | abcd4index | 5 | attr_15 | A | 16354 | NULL | NULL | YES | BTREE | | | NO |
  36. | products | 1 | abcd4index | 6 | attr_16 | A | 28144 | NULL | NULL | YES | BTREE | | | NO |
  37. | products | 1 | abcd5index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  38. | products | 1 | abcd5index | 2 | sub_category_id | A | 990 | NULL | NULL | YES | BTREE | | | NO |
  39. | products | 1 | abcd5index | 3 | attr_17 | A | 1420 | NULL | NULL | YES | BTREE | | | NO |
  40. | products | 1 | abcd5index | 4 | attr_18 | A | 4654 | NULL | NULL | YES | BTREE | | | NO |
  41. | products | 1 | abcd5index | 5 | attr_19 | A | 7424 | NULL | NULL | YES | BTREE | | | NO |
  42. | products | 1 | abcd5index | 6 | attr_20 | A | 7659 | NULL | NULL | YES | BTREE | | | NO |
  43. | products | 1 | abcd6index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  44. | products | 1 | abcd6index | 2 | sub_category_id | A | 397 | NULL | NULL | YES | BTREE | | | NO |
  45. | products | 1 | abcd6index | 3 | attr_21 | A | 1642 | NULL | NULL | YES | BTREE | | | NO |
  46. | products | 1 | abcd6index | 4 | attr_22 | A | 1683 | NULL | NULL | YES | BTREE | | | NO |
  47. | products | 1 | abcd6index | 5 | attr_23 | A | 2401 | NULL | NULL | YES | BTREE | | | NO |
  48. | products | 1 | abcd6index | 6 | attr_24 | A | 4416 | NULL | NULL | YES | BTREE | | | NO |
  49. | products | 1 | abcd7index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  50. | products | 1 | abcd7index | 2 | sub_category_id | A | 491 | NULL | NULL | YES | BTREE | | | NO |
  51. | products | 1 | abcd7index | 3 | attr_25 | A | 1157 | NULL | NULL | YES | BTREE | | | NO |
  52. | products | 1 | abcd7index | 4 | attr_26 | A | 10001 | NULL | NULL | YES | BTREE | | | NO |
  53. | products | 1 | abcd7index | 5 | attr_27 | A | 11580 | NULL | NULL | YES | BTREE | | | NO |
  54. | products | 1 | abcd7index | 6 | attr_28 | A | 6631 | NULL | NULL | YES | BTREE | | | NO |
  55. | products | 1 | abcd8index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  56. | products | 1 | abcd8index | 2 | sub_category_id | A | 639 | NULL | NULL | YES | BTREE | | | NO |
  57. | products | 1 | abcd8index | 3 | attr_29 | A | 882 | NULL | NULL | YES | BTREE | | | NO |
  58. | products | 1 | abcd8index | 4 | attr_30 | A | 2937 | NULL | NULL | YES | BTREE | | | NO |
  59. | products | 1 | abcd8index | 5 | attr_31 | A | 5074 | NULL | NULL | YES | BTREE | | | NO |
  60. | products | 1 | abcd8index | 6 | attr_32 | A | 4473 | NULL | NULL | YES | BTREE | | | NO |
  61. | products | 1 | abcd9index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  62. | products | 1 | abcd9index | 2 | sub_category_id | A | 551 | NULL | NULL | YES | BTREE | | | NO |
  63. | products | 1 | abcd9index | 3 | attr_33 | A | 624 | NULL | NULL | YES | BTREE | | | NO |
  64. | products | 1 | abcd9index | 4 | attr_34 | A | 2236 | NULL | NULL | YES | BTREE | | | NO |
  65. | products | 1 | abcd9index | 5 | attr_35 | A | 3591 | NULL | NULL | YES | BTREE | | | NO |
  66. | products | 1 | abcd9index | 6 | attr_36 | A | 3700 | NULL | NULL | YES | BTREE | | | NO |
  67. | products | 1 | abcd10index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  68. | products | 1 | abcd10index | 2 | sub_category_id | A | 466 | NULL | NULL | YES | BTREE | | | NO |
  69. | products | 1 | abcd10index | 3 | attr_37 | A | 575 | NULL | NULL | YES | BTREE | | | NO |
  70. | products | 1 | abcd10index | 4 | attr_38 | A | 1370 | NULL | NULL | YES | BTREE | | | NO |
  71. | products | 1 | abcd10index | 5 | attr_39 | A | 1373 | NULL | NULL | YES | BTREE | | | NO |
  72. | products | 1 | abcd10index | 6 | attr_40 | A | 1409 | NULL | NULL | YES | BTREE | | | NO |
  73. | products | 1 | abcd11index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  74. | products | 1 | abcd11index | 2 | sub_category_id | A | 448 | NULL | NULL | YES | BTREE | | | NO |
  75. | products | 1 | abcd11index | 3 | attr_41 | A | 720 | NULL | NULL | YES | BTREE | | | NO |
  76. | products | 1 | abcd11index | 4 | attr_42 | A | 2035 | NULL | NULL | YES | BTREE | | | NO |
  77. | products | 1 | abcd11index | 5 | attr_43 | A | 604 | NULL | NULL | YES | BTREE | | | NO |
  78. | products | 1 | abcd11index | 6 | attr_44 | A | 2253 | NULL | NULL | YES | BTREE | | | NO |
  79. | products | 1 | abce12index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  80. | products | 1 | abce12index | 2 | sub_category_id | A | 530 | NULL | NULL | YES | BTREE | | | NO |
  81. | products | 1 | abce12index | 3 | attr_45 | A | 443 | NULL | NULL | YES | BTREE | | | NO |
  82. | products | 1 | abce12index | 4 | attr_46 | A | 767 | NULL | NULL | YES | BTREE | | | NO |
  83. | products | 1 | abce12index | 5 | attr_47 | A | 2834 | NULL | NULL | YES | BTREE | | | NO |
  84. | products | 1 | abce12index | 6 | attr_48 | A | 2561 | NULL | NULL | YES | BTREE | | | NO |
  85. | products | 1 | abcd13index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  86. | products | 1 | abcd13index | 2 | sub_category_id | A | 875 | NULL | NULL | YES | BTREE | | | NO |
  87. | products | 1 | abcd13index | 3 | attr_49 | A | 683 | NULL | NULL | YES | BTREE | | | NO |
  88. | products | 1 | abcd13index | 4 | attr_50 | A | 671 | NULL | NULL | YES | BTREE | | | NO |
  89. | products | 1 | abcd13index | 5 | attr_51 | A | 735 | NULL | NULL | YES | BTREE | | | NO |
  90. | products | 1 | abcd13index | 6 | attr_52 | A | 1813 | NULL | NULL | YES | BTREE | | | NO |
  91. | products | 1 | abcd14index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  92. | products | 1 | abcd14index | 2 | sub_category_id | A | 404 | NULL | NULL | YES | BTREE | | | NO |
  93. | products | 1 | abcd14index | 3 | attr_53 | A | 640 | NULL | NULL | YES | BTREE | | | NO |
  94. | products | 1 | abcd14index | 4 | attr_54 | A | 967 | NULL | NULL | YES | BTREE | | | NO |
  95. | products | 1 | abcd14index | 5 | attr_55 | A | 2084 | NULL | NULL | YES | BTREE | | | NO |
  96. | products | 1 | abcd14index | 6 | attr_56 | A | 1593 | NULL | NULL | YES | BTREE | | | NO |
  97. | products | 1 | abcd15index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  98. | products | 1 | abcd15index | 2 | sub_category_id | A | 770 | NULL | NULL | YES | BTREE | | | NO |
  99. | products | 1 | abcd15index | 3 | attr_57 | A | 755 | NULL | NULL | YES | BTREE | | | NO |
  100. | products | 1 | abcd15index | 4 | attr_58 | A | 986 | NULL | NULL | YES | BTREE | | | NO |
  101. | products | 1 | abcd15index | 5 | attr_59 | A | 1370 | NULL | NULL | YES | BTREE | | | NO |
  102. | products | 1 | abcd15index | 6 | attr_60 | A | 443 | NULL | NULL | YES | BTREE | | | NO |
  103. | products | 1 | abcd16index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  104. | products | 1 | abcd16index | 2 | sub_category_id | A | 455 | NULL | NULL | YES | BTREE | | | NO |
  105. | products | 1 | abcd16index | 3 | attr_61 | A | 384 | NULL | NULL | YES | BTREE | | | NO |
  106. | products | 1 | abcd16index | 4 | attr_62 | A | 540 | NULL | NULL | YES | BTREE | | | NO |
  107. | products | 1 | abcd16index | 5 | attr_63 | A | 1232 | NULL | NULL | YES | BTREE | | | NO |
  108. | products | 1 | abcd16index | 6 | attr_64 | A | 2325 | NULL | NULL | YES | BTREE | | | NO |
  109. | products | 1 | abcd17index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  110. | products | 1 | abcd17index | 2 | sub_category_id | A | 935 | NULL | NULL | YES | BTREE | | | NO |
  111. | products | 1 | abcd17index | 3 | attr_65 | A | 437 | NULL | NULL | YES | BTREE | | | NO |
  112. | products | 1 | abcd17index | 4 | attr_66 | A | 541 | NULL | NULL | YES | BTREE | | | NO |
  113. | products | 1 | abcd17index | 5 | attr_67 | A | 657 | NULL | NULL | YES | BTREE | | | NO |
  114. | products | 1 | abcd17index | 6 | attr_68 | A | 629 | NULL | NULL | YES | BTREE | | | NO |
  115. | products | 1 | abcd18index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  116. | products | 1 | abcd18index | 2 | sub_category_id | A | 613 | NULL | NULL | YES | BTREE | | | NO |
  117. | products | 1 | abcd18index | 3 | attr_69 | A | 505 | NULL | NULL | YES | BTREE | | | NO |
  118. | products | 1 | abcd18index | 4 | attr_70 | A | 521 | NULL | NULL | YES | BTREE | | | NO |
  119. | products | 1 | abcd18index | 5 | attr_71 | A | 423 | NULL | NULL | YES | BTREE | | | NO |
  120. | products | 1 | abcd18index | 6 | attr_72 | A | 679 | NULL | NULL | YES | BTREE | | | NO |
  121. | products | 1 | abcd19index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  122. | products | 1 | abcd19index | 2 | sub_category_id | A | 563 | NULL | NULL | YES | BTREE | | | NO |
  123. | products | 1 | abcd19index | 3 | attr_73 | A | 373 | NULL | NULL | YES | BTREE | | | NO |
  124. | products | 1 | abcd19index | 4 | attr_74 | A | 498 | NULL | NULL | YES | BTREE | | | NO |
  125. | products | 1 | abcd19index | 5 | attr_75 | A | 761 | NULL | NULL | YES | BTREE | | | NO |
  126. | products | 1 | abcd19index | 6 | attr_76 | A | 569 | NULL | NULL | YES | BTREE | | | NO |
  127. | products | 1 | abcd20index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  128. | products | 1 | abcd20index | 2 | sub_category_id | A | 403 | NULL | NULL | YES | BTREE | | | NO |
  129. | products | 1 | abcd20index | 3 | attr_77 | A | 500 | NULL | NULL | YES | BTREE | | | NO |
  130. | products | 1 | abcd20index | 4 | attr_78 | A | 962 | NULL | NULL | YES | BTREE | | | NO |
  131. | products | 1 | abcd20index | 5 | attr_79 | A | 544 | NULL | NULL | YES | BTREE | | | NO |
  132. | products | 1 | abcd20index | 6 | attr_80 | A | 781 | NULL | NULL | YES | BTREE | | | NO |
  133. | products | 1 | abcd21index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  134. | products | 1 | abcd21index | 2 | sub_category_id | A | 934 | NULL | NULL | YES | BTREE | | | NO |
  135. | products | 1 | abcd21index | 3 | attr_81 | A | 546 | NULL | NULL | YES | BTREE | | | NO |
  136. | products | 1 | abcd21index | 4 | attr_82 | A | 826 | NULL | NULL | YES | BTREE | | | NO |
  137. | products | 1 | abcd21index | 5 | attr_83 | A | 546 | NULL | NULL | YES | BTREE | | | NO |
  138. | products | 1 | abcd21index | 6 | attr_84 | A | 658 | NULL | NULL | YES | BTREE | | | NO |
  139. | products | 1 | abcd22index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  140. | products | 1 | abcd22index | 2 | sub_category_id | A | 875 | NULL | NULL | YES | BTREE | | | NO |
  141. | products | 1 | abcd22index | 3 | attr_85 | A | 583 | NULL | NULL | YES | BTREE | | | NO |
  142. | products | 1 | abcd22index | 4 | attr_86 | A | 834 | NULL | NULL | YES | BTREE | | | NO |
  143. | products | 1 | abcd22index | 5 | attr_87 | A | 708 | NULL | NULL | YES | BTREE | | | NO |
  144. | products | 1 | abcd22index | 6 | attr_88 | A | 444 | NULL | NULL | YES | BTREE | | | NO |
  145. | products | 1 | abcd23index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  146. | products | 1 | abcd23index | 2 | sub_category_id | A | 736 | NULL | NULL | YES | BTREE | | | NO |
  147. | products | 1 | abcd23index | 3 | attr_89 | A | 458 | NULL | NULL | YES | BTREE | | | NO |
  148. | products | 1 | abcd23index | 4 | attr_90 | A | 486 | NULL | NULL | YES | BTREE | | | NO |
  149. | products | 1 | abcd23index | 5 | attr_91 | A | 611 | NULL | NULL | YES | BTREE | | | NO |
  150. | products | 1 | abcd23index | 6 | attr_92 | A | 556 | NULL | NULL | YES | BTREE | | | NO |
  151. | products | 1 | abcd24index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  152. | products | 1 | abcd24index | 2 | sub_category_id | A | 611 | NULL | NULL | YES | BTREE | | | NO |
  153. | products | 1 | abcd24index | 3 | attr_93 | A | 514 | NULL | NULL | YES | BTREE | | | NO |
  154. | products | 1 | abcd24index | 4 | attr_94 | A | 834 | NULL | NULL | YES | BTREE | | | NO |
  155. | products | 1 | abcd24index | 5 | attr_95 | A | 430 | NULL | NULL | YES | BTREE | | | NO |
  156. | products | 1 | abcd24index | 6 | attr_96 | A | 458 | NULL | NULL | YES | BTREE | | | NO |
  157. | products | 1 | abcd25index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  158. | products | 1 | abcd25index | 2 | sub_category_id | A | 444 | NULL | NULL | YES | BTREE | | | NO |
  159. | products | 1 | abcd25index | 3 | attr_97 | A | 625 | NULL | NULL | YES | BTREE | | | NO |
  160. | products | 1 | abcd26index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  161. | products | 1 | abcd26index | 2 | sub_category_id | A | 403 | NULL | NULL | YES | BTREE | | | NO |
  162. | products | 1 | abcd26index | 3 | attr_98 | A | 667 | NULL | NULL | YES | BTREE | | | NO |
  163. | products | 1 | abcd27index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  164. | products | 1 | abcd27index | 2 | sub_category_id | A | 722 | NULL | NULL | YES | BTREE | | | NO |
  165. | products | 1 | abcd27index | 3 | attr_98 | A | 847 | NULL | NULL | YES | BTREE | | | NO |
  166. | products | 1 | abcd28index | 1 | main_category_id | A | 35 | NULL | NULL | YES | BTREE | | | NO |
  167. | products | 1 | abcd28index | 2 | sub_category_id | A | 569 | NULL | NULL | YES | BTREE | | | NO |
  168. | products | 1 | abcd28index | 3 | attr_99 | A | 542 | NULL | NULL | YES | BTREE | | | NO |
  169. | products | 1 | fulltext_index_products | 1 | name | NULL | NULL | NULL | NULL | YES | FULLTEXT | | | NO |
  170. | products | 1 | fulltext_index_products | 2 | part_number | NULL | NULL | NULL | NULL | YES | FULLTEXT | | | NO |
  171. | products | 1 | fulltext_index_products | 3 | ctyea_part_number | NULL | NULL | NULL | NULL | YES | FULLTEXT | | | NO |
  172. | products | 1 | fulltext_index_products | 4 | manufacturer | NULL | NULL | NULL | NULL | YES | FULLTEXT | | | NO |
  173. +----------+------------+-------------------------------------+--------------+-------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
  174. 168 rows in set (0.001 sec)
  175.  
  176.  
  177.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!