Low SQL cost and high execution time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gregor Kovač - 18 Jan 2006 12:44 GMT

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

Signature

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

| Gregor Kovac | Gregor.Kovac@mikropis.si |

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

| In A World Without Fences Who Needs Gates? |
| Experience Linux. |

-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~

Reply to this Message

leonardobgil@gmail.com - 18 Jan 2006 14:41 GMT

Run db2advis against the query.

It may give you more information on what you need to do to speed it up

Leo

Reply to this Message