Re: querying time is too high
Can you provide the table structure of the usr_tbl table along with the output of EXPLAIN?
Have you tried running OPTIMIZE and ANALYZE on the table before running the query?
Since you are doing a GROUP BY what is the size of your sort_buffer_size variable?
Great spirits have always found violent opposition from mediocre minds. The latter cannot understand it when a person does not thoughtlessly submit to hereditary prejudices but honestly and courageously uses their intelligence.
Subject
Views
Written By
Posted
2877
June 27, 2006 07:31AM
Re: querying time is too high
1951
June 28, 2006 10:00AM
1909
June 29, 2006 12:48AM
1912
June 29, 2006 08:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.