Are soft deletes better than hard deletes?

- What's hard delete:Performing a delete query to delete a record permanently from the table. - What's soft delete:Flagging a record as deleted in a table, instead of actually deleting the record. - What happens when we do a hard delete? A search q...