For MySQL DB, if the records number exceeds one million in one single table, which...

Alibaba Cloud ACA-Sec1 Question Answer

For MySQL DB, if the records number exceeds one million in one single table, which of the

following methods can help you improve querying speed?(the number of correct answers: 2)

Score 1

setup index for this table

use 'group by' to filter information

use 'count(*)' to get total record number before query

use 'limit N' to limit the number of possible returned records

ACA-Sec1 PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"