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?
Question
It that possible query optimization ?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.