It does not look like business question. I guess it's about databases, so next time post it in Computer and Technology section. Anyway, I know the answer: The sort cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions. Cache allows to load data faster as this data is stored in the storage and doesn't need to be downloaded.