SQL query optimization
- by nvtthang
I have a problem with my SQL query that take time to get all records from database. Any body help me. Below is a sample of database:
order(order_id, order_nm)
customer(customer_id, customer_nm)
orderDetail(orderDetail_id, order_id, orderDate, customer_id, Comment)
I want to get latest customer and order detail information.
Here is may…