EXPLAIN QUERY PLAN

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
egrobler
Posts: 26
Joined: Mon 03 Dec 2012 14:35

EXPLAIN QUERY PLAN

Post by egrobler » Fri 08 Dec 2017 11:28

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
Devart Team
Posts: 1030
Joined: Mon 06 Jul 2015 11:34

Re: EXPLAIN QUERY PLAN

Post by MaximG » Fri 08 Dec 2017 13:25

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
Posts: 26
Joined: Mon 03 Dec 2012 14:35

Re: EXPLAIN QUERY PLAN

Post by egrobler » Mon 11 Dec 2017 19:58

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
Devart Team
Posts: 1030
Joined: Mon 06 Jul 2015 11:34

Re: EXPLAIN QUERY PLAN

Post by MaximG » Tue 12 Dec 2017 06:47

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

Post Reply