Oracle:
添加索引:
Create Index CONTACTbid On M_CONTACT_INFO(business_id);
MongoDB:
区间查询:
db.getCollection('repay_batch_info').find({"batch_no":{"$gt":"mnwp2pt005","$lt":"mnwp2pt107"}})
and查询:
db.getCollection('loan_instruction').find({$and:[{"channel_code" : "xmjr"},{"status" : "SUCCESS"}]})