@musicmaster I've compared the indexes from ps_specific_price table in my store database and fresh installation of the same prestashop version. It looks like all the indexes are there. The only difference I see is the number in the cardinality (moc) column which corresponds to the number of products with specific prices. I'm attaching the screenshots.
Fresh installation:
My store: