Why I can't see index created with
CREATE INDEX query in Indexes tab in HeidiSQL?
I've just created
full_name_index with the following query:
CREATE INDEX `full_name_index` ON `users` (`name`, `surname`);
And it doesn't show up in the Indexes tab in here:
However, I can see the index when I use the following query:
SHOW INDEX FROM `users` FROM `dirask`;
Result of the above query:
The solution was to refresh the database like 5 times using F5 because once didn't work.