Viewing 10 posts - 1 through 10 (of 10 total)
Hi Jeff & Matt,
Thanks very much for all your advise. I wonder if I could pick your brains once more? How you would add to your query to output 3...
March 7, 2008 at 9:03 am
Hi Matt,
Thanks very much for your input. I indexed as you said and it does run quicker. However, when I ran the "Index Tuning Wizard" it recommened:
[Open%] ,[High%], [Low%], [Close%],...
March 6, 2008 at 12:16 pm
Hi Matt,
Thanks for the reply. When you say: "...On the temp table - you would create the index immediately after the temp table was created (after the SELECT...INTO)", what is...
March 6, 2008 at 9:22 am
Hi Jeff,
Ran your query and it took 20 seconds as compared to the nearly 2 minutes with the nested query !! I have to say that I’m not au fait...
March 4, 2008 at 9:51 am
Hi Jeff,
Thanks for your reply. Still not too sure where the tmptable is stored/held? And, when you suggest building a full blown covering index on you main table, how and...
March 4, 2008 at 7:33 am
Hi Jeff,
Sorry for being a bit thick, but I ran the query in a View and couldn't find the tmptable it created. I then ran the query in the query...
March 4, 2008 at 3:45 am
Thanks very much Jeff. I'll give that a go later today !!!
March 4, 2008 at 2:29 am
Hello Jeff,
Thank you for your reply and thanks for explaining best practises. Sorry I havent got back to your earlier, but I have been away from work. Please find the...
March 3, 2008 at 4:10 am
Hi Peter,
It was more of a general question and that fact you said it ‘depends’ probably answers it.
A specific situation is a parts table that can be joined to...
April 17, 2007 at 4:30 am
Viewing 10 posts - 1 through 10 (of 10 total)