Everyone a great god I have a question - now have two tables a table data only 10 a table data about several t, big saved the little table in the table need to query field, I am now with a small table of the leftist writers, correlates to query out of this field, especially slow, will there be any way to improve speed,

CodePudding user response:

Several terabytes of data, to query out, however, are slow, you with what conditions?

CodePudding user response:

Only with associative table field is the big table's primary key

CodePudding user response:

On a left join b=a.f id b.i d id is the primary key index b b table table data ridiculously sad

CodePudding user response:

Have a great god know how to optimize

CodePudding user response:

Only check 1 the first look at what speed, field index, index execution plan is go

CodePudding user response:

Should walk NL
Your B on the table already has index
The returned result have how old?
No other filtration or filter condition?

CodePudding user response:

Special slow, is how slow
What is the query result is

CodePudding user response:

Take out your SQL statement execution plan and have a look