The concepts like clustering, physical organization, unique, primary, secondary, composite keys — these stuffs are same in all database servers. The commands and their outputs, the last part of ‘what happens under the hood' and creation of primary index only on primary key are very specific to MySQL. In fact in Oracle, there is something called index organized table which is equivalent to clustering index in MySQL. so more or less fundamentals are pretty much same. Regarding how query optimizer chooses which index to use during what kind of query is something which is subjective and I have not discussed them much here.

Written by

Deep discussions on problem solving, distributed systems, computing concepts, real life systems designing. Developer @PayPal.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store