Paul Malan wrote: > That is a huge improvement! The execution time is lower than 10 > seconds now - that's amazing.
I think that is still rather long. Can you update the execution plan and index pages if you need it to go even faster? > For clarification, when I set up the index all I did was give it a > name and tell it which column to index, then pressed OK. Nothing more > to it? Do I need to do anything to tell the db to create the index, > or does it just do that when I name it? That should be enough. Did you do that for the tick, ordr and ordl tables or just for one? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189049 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
