The Message table data quantity is large, there are about millions of data every day,
Message table contains the fields, the ID, the Content, the Amount and CDate. The CDate is time type, the table to CDate partitions, ID column has established the global index, the Amount column set up a global index,

Select id, the content from the Message where cdate> The date '2020-1-1' and cdate & lt; The date '2020-2-1' and amount> 10;

Corresponding to the SQL, it also going global partition? I understand is that the process of it find the partition's file first, and then directly from the file query, no index,