Select *
From <table> AS T
Where T.x = 1111 AND T.y = "fdsfsdf" AND T.z = 8888 AND ...
有没有办法优化该查询?
对于此查询:
Select *
From t
Where T.x = 1111 AND T.y = 'fdsfsdf' AND T.z = 8888 AND . . .
您需要一个索引。 对于您提供的内容,最佳索引按任意顺序具有三列:
create index idx_t_xyz on t(x, y, z);