2

Does Sqlite create a "query plan" for the complex queries? (I know mysql creates one and chooses the best of different available combination to execute the query). Is there any way i can get last_query_cost as i usually get in mysql. i am trying to migrate from mysql to sqlite due to some resource requirement for my application.

RichardTheKiwi
  • 105,798
  • 26
  • 196
  • 262
user530928
  • 109
  • 2
  • 9
  • 1
    possible duplicate of [How can I analyse a Sqlite query execution?](http://stackoverflow.com/questions/1454188/how-can-i-analyse-a-sqlite-query-execution) – Byron Whitlock Jan 23 '11 at 20:48
  • its not the question is whether sqllite really support query estimator/query plan optimizer and have variable like last_query_cost. – user530928 Jan 31 '11 at 04:18

1 Answers1

2

SQLite supports the EXPLAIN keyword, like MySQL, but syntax is slightly different:

EXPLAIN QUERY PLAN SELECT col FROM YOUR_TABLE
OMG Ponies
  • 325,700
  • 82
  • 523
  • 502
  • Thanks for the reply. is there anything equivalent to last_query_cost(works for mysql) in sqlite? – user530928 Jan 23 '11 at 21:05
  • @user530928: Not that I can see in the documentation. SQLite doesn't have as many features as MySQL, because it's primary intended as an embedded database -- smaller footprint. – OMG Ponies Jan 23 '11 at 21:08