EXPLAIN QUERY PLAN

[egrobler]

Hi DevArt

I want to see if an index is used.
EXPLAIN QUERY PLAN seems to not return any rows.
Is this supported?

Code: Select all

EXPLAIN QUERY PLAN select * from table where col='xxx'

[MaximG]

We tested the work of LiteDAC 3.1.3 according to your description and found no problems. Please check the work of your query using SQLite command-line tools, available at the project website: http://www.sqlite.org/download.html In case of getting the correct result, please compose and send us a small test project, in which the issue occurs. In addition, we will need the SQLite database file used in this sample. For this, use the e-support form (https://www.devart.com the "Support"\"Request Support" menu)

[egrobler]

Hi MaxinG,

Sorry for wasting your time, I have a sqlite text editor that looked at the type of query 'select, update, pragma etc' and the explain query type was not included.

It now works perfectly.

Thank you

[MaximG]

We are glad that you found a necessary solution. Please don't hesitate to contact us with questions concerning LiteDAC usage.