CREATE NONCLUSTERED INDEX IX_invInvoice_BookingId

ON invInvoice (invRebBookingId, invDeleted, invDate DESC)

INCLUDE (invUId);

 

 

 

CREATE NONCLUSTERED INDEX IX_iniInvoiceItem_InvoiceId

ON iniInvoiceItem (iniInvInvoiceId, iniDeleted)

INCLUDE (iniInpPaymentId, iniDueDate, iniValue);

 

 

CREATE NONCLUSTERED INDEX IX_inpInvoicePayment_UId

ON inpInvoicePayment (inpUId)

INCLUDE (inpMode);