Cool! Thanks a lot Shawn.
> No, but you can. Modify your scripts so that the word EXPLAIN is the first
> thing in each one then re-execute them. This will product the optimizer's
> execution plan for each query. The results of all of those EXPLAIN
> SELECT statements will give us the most inf
No, but you can. Modify your scripts so that the word EXPLAIN is the first
thing in each one then re-execute them. This will product the optimizer's
execution plan for each query. The results of all of those EXPLAIN
SELECT statements will give us the most information to work from.
Thanks.
The following are the real tests but not the real logic i'll apply:-)
i have 4 very simple script files below and like to show you the performance differece
tst0.sql:
select t1.participation_id id, t1.owner_id from participation t1 where
(t1.participation_id in (24,469)) and
(t1.property_dic