Re: anyway to optimize this query?

>query only. Well, then, why not create all possible index combinations? :-) >Obnoxio The Clown wrote: > >> Sometimes it helps to treat a 2 CPU box as a single CPU box. Have you >> tried this? >> >> >PHYSBUFF 32 # Physical log buffer size (Kbytes) >> >LOGBUFF 32 # Logical log buffer size (Kbytes)>> >> Might try bigger PHYSBUFF and LOGBUFF, unless you're using unbuffered >> logging. >> >> >CLEANERS 4 # Number of buffer cleaner processes>> >> Do you only have 4 disks? How come you've got more AIO VPs than >> cleaners? >> >> >LRUS 4 # Number of LRU queues>> >> Why do you have so few LRU queues? >> >> >DBSPACETEMP tempdb1 # Default temp dbspaces>> >> Add some more temp dbspaces. >> >> >MAX_PDQPRIORITY 12 # Maximum allowed pdqpriority >> >DS_MAX_QUERIES 8 # Maximum number of decision support>> queries >> > >> >DS_TOTAL_MEMORY 36000 # Decision support memory (Kbytes) >> >DS_MAX_SCANS 150 # Maximum number of decision support>> scans >> >> Are you running this as a PDQ query? If you are, turn that off and try >> again. >> >> Is the database query-only, or are you doing lots of updates and >> inserts? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com