Page 1 of 1
EXPLAIN QUERY PLAN
Posted: Fri 08 Dec 2017 11:28
by 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'
Re: EXPLAIN QUERY PLAN
Posted: Fri 08 Dec 2017 13:25
by 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)
Re: EXPLAIN QUERY PLAN
Posted: Mon 11 Dec 2017 19:58
by 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
Re: EXPLAIN QUERY PLAN
Posted: Tue 12 Dec 2017 06:47
by MaximG
We are glad that you found a necessary solution. Please don't hesitate to contact us with questions concerning LiteDAC usage.