我在cfloop中有查询，这使得过程非常缓慢。有没有办法使这个查询更快？SELECT*FROMCheckRegister,ExpenseTypeWherePropertyID=10andExpenseType.ExpenseTypeID=CheckRegister.ExpenseTypeIDSELECT*FROMVendorsWHEREVendorID=#VendorID#SelectTenantTransactionDateasfromDateFromTenantTransactionsWhereCheckRegisterID=#CheckRegisterID#OrderByTena