You're right, I'm sorry.
At the moment, we review the schema for tables and indexes and decided
redesigned. I detected a loop in the join, because we only have a integer
sequencial like PK and no composite keys in the tables. I think that is the
mainly problem.
Thanks!
-
Dame un poco de
On 03/21/2017 04:27 PM, DrakoRod wrote:
Hi folks!
I've a query with a join of two tables. One table have a 5 millions rows and
child table have a 17 millions rows. The query is executed many times in
application, every 20 seconds aproximately.
The query normally execute in 2-3 seconds but in
Hi folks!
I've a query with a join of two tables. One table have a 5 millions rows and
child table have a 17 millions rows. The query is executed many times in
application, every 20 seconds aproximately.
The query normally execute in 2-3 seconds but in some time without apparent
pattern the