How many columns can you create for an index? - Study24x7
Social learning Network

Warning: include(./views/auth.php): failed to open stream: Permission denied in /var/www/html/live/loginRightSlider.php on line 18

Warning: include(): Failed opening './views/auth.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/live/loginRightSlider.php on line 18
22 followers study24x7 04 Dec 2019 06:59 PM study24x7 study24x7

How many columns can you create for an index?

A

16

B

3306

C

100

D

All

study24x7
Write a comment
  • DBA Consultant
  • MySQL can create composite indexes (that is, indexes on multiple columns). An index may consist of up to 16 columns
    Related Questions
    500+   more Questions to answer
    Most Related Articles