Skip to main content
Question

It that possible query optimization ?

  • September 23, 2020
  • 1 reply
  • 3 views

HyeontaeJu
Forum|alt.badge.img+2

Hello, I have 4 big table a, b, c, d. each table have about 300 million data.
I wanna inner join a, b, c, d. but, when i was using this query, the cpu usage is top in the system..
Even this query is intended to be used on a web page as a paging query, so it should appear within at least 10 seconds. Is this possible?