I didn't know about this functionality. I know it is a 'sharp tool', but what I've gathered out by reading the document is that this only affects indexes, and if I understand the doc, only when the imposter table is created or is used to modify the indexes. What if an imposter table is created at database inception, and is not changed or modified, and only used for R/O queries? Does it become a blunt instrument or is it still a sharp utility knife?
Personally, I doubt I'd ever use this. I've never required knowledge of what the index is beyond faith in knowing that the engine knows what its doing, or, needs to get updated periodically. (I know of different methods of indexing in different engines, but, never needed to know which is used or implemented) On Wed, Jun 14, 2017 at 8:22 AM, Paul Sanderson < sandersonforens...@gmail.com> wrote: > Can you create an imposter table on a view. A view has no associated b-tree > so I would think not! > > Paul > www.sandersonforensics.com > skype: r3scue193 > twitter: @sandersonforens > Tel +44 (0)1326 572786 > http://sandersonforensics.com/forum/content.php?195-SQLite- > Forensic-Toolkit > -Forensic Toolkit for SQLite > email from a work address for a fully functional demo licence > > On 14 June 2017 at 13:11, Simon Slavin <slav...@bigfraud.org> wrote: > > > > > > > On 14 Jun 2017, at 12:52pm, Paul Sanderson <sandersonforens...@gmail.com > > > > wrote: > > > > > The only benefit I can see is that you know the imposter table is > showing > > > you exactly what is in the index, where the view is my interpretation > of > > > the SQL needed to show what is in the index. Is this the main benefit? > or > > > am I missing something? > > > > Hmm. If you create a view with calculated columns, and then create an > > impostor table on that view, do you get a virtual table with > pre-calculated > > columns ? > > > > Simon. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users