我们要求从表中加载最近30天的更新数据.
下面的潜在解决方案之一不允许这样做.
select * from XYZ_TABLE where WRITETIME(lastupdated_timestamp) > (TOUNIXTIMESTAMP(now())-42,300,000); select * from XYZ_TABLE where lastupdated_timestamp > (TOUNIXTIMESTAMP(now())-42,000);
该表有列
lastupdated_timestamp (with an index on this field) lastupdated_userid (with an index on this field)
任何指针……