My data must level, with the following statement to execute queries, super slow, faster statements,

Select table a. *, table b. *

the from list AWHERE 'date' & gt;
='2020-12-01'The join table B on table a. 'serial number=table b.' serial number '

CodePudding user response:

You this back with * must be fast, and generally use less as far as possible the join
Select A. *, * from b. tableA A, tableB B where a. sh=b.l sh and a.r q> '2020-12-01'