Le 12/09/2012 05:17, Fred Taylor a écrit : > You do have an index tag on DATE in all the tables, right? > > Fred PUBLIC gcworkplan =SYS(3092, "optimisation.txt") =SYS(3054, 12, gcworkplan) your query goes here =SYS(3054, 0) =SYS(3092, "")
Run this program and open the file optimisation.txt to see what you can do to optimize your query. In gcworkstation, you'll find the showplan informations but it's less usable. The Foxil _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
