Re: [GENERAL] EXPLAIN on DELETE statements

2004-08-01 Thread Grant McLean
On Wed, 2004-07-28 at 23:41, Janning Vygen wrote: > Hi, > > EXPLAIN on delete stamements works, but doesn't show me all the subsequent > deletes or checks which has to be done because of foreign keys > cascading/restricting. > > Is there a solution to show up which tables are checked and which

[GENERAL] EXPLAIN on DELETE statements

2004-07-28 Thread Janning Vygen
Hi, EXPLAIN on delete stamements works, but doesn't show me all the subsequent deletes or checks which has to be done because of foreign keys cascading/restricting. Is there a solution to show up which tables are checked and which scans the planner is going to use to check these related tables