|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
June 11th, 2007, 07:41 PM
|
|||
|
|||
|
Evaluate indexes running slowly
I am trying to use the evaluate indexes to estimate query cost. For queries, even if I have a blank advise_index table, the time to execute evaluate indexes for the workload is 10x the cost it actually evaluates.
Also, it seems that every time a query uses an already existing index, it adds that index into the advise_index table. Are these two things normal? Thanks!
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > Evaluate indexes running slowly |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
