What is the "optimization ratio or status" reported by dbd?

[sarah]

Hi,

I provided several queries to DBD to optimize. What is the meaning of the numbers reported by DBD?

For example, my output shows:

Query 1 optimization ratio or status is 1
Query 2 optimization ratio or status is 1
Query 3 optimization ratio or status is 1.02
Query 4 optimization ratio or status is 0.9

What do the 1, 1, 1.2 and 0.9 refer to?

Thanks