Explain also gives approx row counts and other info.
On September 4, 2015 9:49:52 AM EDT, Sandro Santilli <s...@keybit.net> wrote:
>On Fri, Sep 04, 2015 at 08:31:39AM -0400, James Keener wrote:
>> Sorry for the double email. Also, I wonder how much we could extract
>> from EXPLAIN SELECT * FROM view; (alternatively EXPLAIN SELECT * FROM
>> view WHERE field1 = 1;) and if we could tease information out of
>that.
>
>Information can be extracted from the result set with a LIMIT 0
>select, and I believe this is what qgis already does.
>
>You can see which tables are being addressed and whether those
>tables have a primary key, but it ain't easy to determine if
>those primary keys will appear uniquely in the output.
>
>--strk;
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
