nipunsadvilkar/index_creation_mysql.md

Created August 17, 2017 12:07

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/nipunsadvilkar/aa5435abaae5fec39295546747583cc4.js"></script>
Save nipunsadvilkar/aa5435abaae5fec39295546747583cc4 to your computer and use it in GitHub Desktop.

create index for mysql tables

Raw

ALTER TABLE `analytics` ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY

SELECT count(distinct encounter_id) FROM `analytics`

CREATE INDEX registration_no ON analytics(registration_no(30));

CREATE INDEX subsection ON analytics(subsection(50));

CREATE INDEX fully_specified_name ON analytics(fully_specified_name(100));