It can speed matching-row lookups but adds storage and maintenance work to writes

It makes reads slower while eliminating work from inserts and updates

It creates a backup copy that affects neither reads nor writes

It improves every query with no disk or write cost