delete from invoice.delivery_search_index where create_date < '2023-01-01';
delete from invoice.delivery_search_index where customer_code >= '20000000';

delete from invoice.delivery_date_index where create_date < '2023-01-01';
delete from invoice.delivery_date_index where customer_code >= '20000000';

delete from invoice.delivery where create_date < '2023-01-01';
delete from invoice.delivery where customer_code >= '20000000';


delete from invoice.invoice_search_index where create_date < '2023-01-01';
delete from invoice.invoice_search_index where customer_code >= '20000000';

delete invoice.invoice_date_index
from invoice.invoice_date_index 
	left outer join invoice.invoice_search_index 
		on invoice.invoice_date_index.invoice_id = invoice.invoice_search_index.invoice_id
where invoice.invoice_search_index.invoice_id is null ;

delete invoice.invoice
from invoice.invoice 
	left outer join invoice.invoice_search_index 
		on invoice.invoice.invoice_id = invoice.invoice_search_index.invoice_id
where invoice.invoice_search_index.invoice_id is null ;