-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Rod Taylor wrote:
|>>What are the times without the index, with the index and with the higher |>>statistics value when using a prepared query? |> |>Using a prepared query: |> |>Without index and default stat 10 : 1.12 ms |>Without index and default stat 1000 : 1.25 ms |>With index and default stat 10: 1.35 ms |>With index and default stat 1000: 1.6 ms |> |>that values are the average obtained after the very first one, |>on 20 execution. | | | Most interesting. And the plans chosen with the 2 different default stat | targets are the same? Sorry if I missed the post indicating they were. | | If the plans are the same, it would be interesting to get a profile on | the 2 different cases with that index in place across 100k iterations of | the prepared query.
Do you have an advice on the profiler to use ?
Regards Gaetano Mendola
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBKHBg7UpzwH2SGd4RAmGCAKDOZ3xXNPFhhGSMN89MssR7UZnY3ACg6sAY mWKo4uAZzv1ZtmBsfQZ2SBc= =NQf/ -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
