0 Replies Latest reply on Sep 25, 2011 11:12 AM by Francisc

    SQLite micro-optimization based on LiveDocs unclear

    Francisc Level 3

      This article on Livedocs says you should add the database name in front of tables.
      http://help.adobe.com/en_US/AIR/1.5/devappsflex/WS5b3ccc516d4fbf351e63e3d118666ade46-7d47. html

       

      My question is, should I do that everywhere where a table name appears or only once?
      In this query:


      select T1.col,T2.col from T1 left join T2 on T1.id=T2.id order by T2.order;

       

      Should I add main.T1 and main.T2 everywhere or just after for, the first time:


      select T1.col,T2.col from main.T1 left join main.T2 on T1.id=T2.id order by T2.order;

       

      Thank you.