1 Reply Latest reply on Oct 30, 2013 7:48 AM by David Miller

    What are others doing with sqllite indexes and statistics?

    Mark Bauer

      I am working on an application that keeps a significant amount of data on the client and am wondering what others are doing for:

       

      1.  Setting up indexes on their SQLlite databases

      2.  Running ANALYZE to keep their queries sharp

       

      My current line of thinking is to run statistics on my tables on the start of the application (these applications will typically be running for weeks at a time), and to somehow script the creation of the indexes into the installation process of the application (maybe there is a built in way to do this?). 

       

      Please share your thoughts!

       

      Thanks,

       

      MAB