Re: Delete performance

Jana wrote:
>
> Hello,
> i have a table with about 250m records from which i want to delete
> thoose not contained in other table. I used this SQL query:
> DELETE FROM data_structures_items WHERE id_data_structure NOT IN (
> SELECT id_structure FROM data_structures);


DELETE FROM data_structures_items, data_structures WHERE
data_structures_items.id_data_structure =
data_structures.id_data_structure AND
data_structures_items.id_data_structure IS NULL;