Hello KTD,

my post is already 3 years old ;-).

The "estimated number of rows" was consequently wrong for one table and i could not improve it by updating statistics. I had...

Hello,

please have a look at this article which should solve your problem:

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/r0011324.htm

We will also try to use "IBM OLEDB for DB2 provider" because for "Microsoft OLEDB for DB2...

Screenshot 9 is the same as Screenshot 8 🙂

Thanks for the advice, our server administrar has chosen to insert a new network card, let's if it helps.

In the execution plan i have seen that for the good server the estimated number of rows is 1 and on the bad server the estimated number of rows is...

Hello,

yes i made a mistake which shows indeed that samething is wrong in the execution plan.

I have forgotten to limit the data in T_AD_ACTUAL_DATE (Where condition).

But as you can see...

- quite the same hardware ~ 20gb ram

- same amount of data in the source tables

- no other loads during my tests on the server

- same schema, etc.

Attached you'll find...

Here the remaining information:

Network Hops:

8

is Oracle server local or remote?

- remote (Sql Server Europe, Oracle US)

how many network hops?

bandwith?

- T1 = 1,544 Mbit/sec.

latency?

- 200ms

how complex is the query reading from...

And what about if you have different servers: Test,Quality and Production. How do you know which version is on which server??

In syscomments and sys.sql_modules there is only the code of procedures and views stored, is there also a possibilty to see the definition of tables and indizes?

The problems with sourcesafe, subversion are:

1. Changes can be made outside of the source control because they are based on flat files and there is no link to the database

2....

That's what i wanted to do. Every change to the database should be logged.

If you have source controll in subversion etc. there is still the possibility to make changes directy...

Thanks HowardW! Thats what i needed to know!

Hello Benyos,

thanks for your quick reply. Unfortunately it does not work, if you copy and paste the source code out there are still no linebrakes 🙁

Another idea?