Re: [sqlite] CREATE INDEX Placement

2014-08-12 Thread Markus Schaber
Hi, Von: Drago, William @ MWG - NARDAEAST > Does it matter if I group all of my CREATE INDEX statements at the end of > my .sql file or should they appear right after each CREATE TABLE statement? > Does SQLITE care one way or another? Semantically, it's equivalent (apart from the fact that you

Re: [sqlite] CREATE INDEX Placement

2014-08-11 Thread Simon Slavin
On 11 Aug 2014, at 5:19pm, Drago, William @ MWG - NARDAEAST wrote: > Does it matter if I group all of my CREATE INDEX statements at the end of my > .sql file or should they appear right after each CREATE TABLE statement? Does > SQLITE care one way or another? The

Re: [sqlite] CREATE INDEX Placement

2014-08-11 Thread Richard Hipp
On Mon, Aug 11, 2014 at 12:19 PM, Drago, William @ MWG - NARDAEAST < william.dr...@l-3com.com> wrote: > All, > > Does it matter if I group all of my CREATE INDEX statements at the end of > my .sql file or should they appear right after each CREATE TABLE statement? > Does SQLITE care one way or

[sqlite] CREATE INDEX Placement

2014-08-11 Thread Drago, William @ MWG - NARDAEAST
All, Does it matter if I group all of my CREATE INDEX statements at the end of my .sql file or should they appear right after each CREATE TABLE statement? Does SQLITE care one way or another? Thanks, -- Bill Drago Senior Engineer L3 Communications / Narda Microwave