Search found 1 match
- Wed Aug 03, 2011 4:43 am
- Forum: Bugs, bug fixes & releases
- Topic: Long-running query against customer table
- Replies: 1
- Views: 4677
Long-running query against customer table
From time to time we'll notice a long-running query on our database server which looks like this: SELECT count(*) FROM ( select cust.customer_id, cust.gender, cust.firstname, cust.lastname, cust.email FROM customer_1_tbl cust ) agn Typically this will take some minutes to complete (there's around 60...