Interview questions for advice! Solution Ideas

Interview questions for advice!
There is a table, there are thousands data, the index query needs 8 seconds, how can I in 0 seconds of time to find them all.
The cache cannot be used because the data is real-time

Heroes, help me with my work.

------Solution--------------------
Is there an answer to your job? This size of data simple sorting paging, the statement is not good to execute a lot of time

This situation allows him to give a table structure, and specific statements. Pushing the ball back to the interviewer

Otherwise, it's impossible to talk about Mission impossible
------Solution--------------------
I've done this test for you. , I wrote a table, inserted 1KW data, the test effect is also possible. You can try a partition, or a table, a table. Query time with the merge type can improve about 80~90%
------Solution--------------------
90% of the data is erased.

