RE: what's wrong with EXPLAIN?

2002-03-11 Thread savaidis
Thanks. But I think, it would be more usefull to INSERT/UPDATE as they change the talbe's contents. Makis -Original Message- From: Cary [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 12:16 AM To: [EMAIL PROTECTED] Subject: Re: what's wrong with EXPLAIN? I am probably

RE: what's wrong with EXPLAIN?

2002-03-11 Thread savaidis
with EXPLAIN? Thanks. But I think, it would be more usefull to INSERT/UPDATE as they change the talbe's contents. Makis -Original Message- From: Cary [mailto:[EMAIL PROTECTED]] Sent: Monday, March 11, 2002 12:16 AM To: [EMAIL PROTECTED] Subject: Re: what's wrong with EXPLAIN

Re: what's wrong with EXPLAIN?

2002-03-10 Thread Cary
I am probably wrong, but my assumption was that EXPLAIN was used to help optimize SELECT statements, not INSERT/UPDATE statements. So if I am thinking correctly (this time :-), EXPALAIN is erroring for you because it only deals with SELECT statements. Cary At 12:10 PM 3/9/02, savaidis wrote: