DB2 Plans

[TMAG]

I have a database that has considerable skew in the values of the
columns in different tables and it is evident in reposnce times when i
run the samme query with different parametres. However when i check the
query plans, they show me the same total cost in timerons for all ranges
of parametres. Any hints why it is happening ? . I did runstats with
distribution on all the tables and indexes.

thanks

[blair kenneth adamache]

Are the explains showing the same plan?

Post by TMAG
I have a database that has considerable skew in the values of the
columns in different tables and it is evident in reposnce times when i
run the samme query with different parametres. However when i check the
query plans, they show me the same total cost in timerons for all ranges
of parametres. Any hints why it is happening ? . I did runstats with
distribution on all the tables and indexes.
thanks

[TMAG]

Yes, exact same plans.

Post by blair kenneth adamache
Are the explains showing the same plan?

Post by TMAG
I have a database that has considerable skew in the values of the
columns in different tables and it is evident in reposnce times when i
run the samme query with different parametres. However when i check
the query plans, they show me the same total cost in timerons for all
ranges of parametres. Any hints why it is happening ? . I did
runstats with distribution on all the tables and indexes.
thanks