Hi!
I have a problem. :)
I have a big SQL statement with about 20 LEFT JOINS. When I run explain on
it it gives me a total cost of about 500, but when I run the query it runs
for about two minutes.
I have updated statistics, but the values did not change.
Any suggestions?
Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
| Gregor Kovac | Gr**********@mikropis.si |
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~