[Spock Proxy Devel] SELECT queries with USING INDEX
Status: Alpha
Brought to you by:
kaotao
From: Niv <ni...@tr...> - 2008-12-03 14:39:35
|
Hello. I have a problem with Spock Proxy. I'm trying to run a query on all shards, and the query contains an index hint ("USE INDEX"): SELECT * FROM <table> USE INDEX (index1, index2) WHERE <conditions> ORDER BY <order> LIMIT 0, 10 In the spockproxy log file, I see the warning "could not parse table alias, using default db". When I remove the "USE INDEX", the query works (but takes forever). Can you please offer any assistance? Thanks, Niv Singer |