Hi,
I want to know about the flow in which delete query is executed in postgres .
Assume i have a following query.
Delete from table_a * where column_a = 'something'
How is this query executed ? Are the rows first filtered out and then deleted one by one ?? Or is the row deleted as and when it is filtered ??
Thanks,
Harsha