From: "Robert Comer" 

> There are indexes for normal query patterns, but I do a lot of ad hoc
mining
> type stuff. What happens is a couple of us will be sitting around
discussing
> some new possibility and I end up running weird queries looking for
> information that can help us decide, it's never the same and if it has an
> index then it's not a problem. It's the ones that don't have an index that
> bog the server and those are so different from each other that I'd have to
> index everything to solve the problem.

I do the same, but when I find one that bogs things down, I build a new
index right away, so the next time I don't have any problems. As long as I
have space I don't even think twice about it -- temp queries usually take
up more when they're running.

- Bob Comer


"Geo."  wrote in message
news:3e10e732$1{at}w3.nls.net...
> "Robert Comer"  wrote in message
> news:3e0fbd97$1{at}w3.nls.net...
>
> > Build 'em to fit your normal query patterns, it'll save you time in the
> long
> > run.
>
> There are indexes for normal query patterns, but I do a lot of ad hoc
mining
> type stuff. What happens is a couple of us will be sitting around
discussing
> some new possibility and I end up running weird queries looking for
> information that can help us decide, it's never the same and if it has an
> index then it's not a problem. It's the ones that don't have an index that
> bog the server and those are so different from each other that I'd have to
> index everything to solve the problem.
>
> Geo.
>
>

--- BBBS/NT v4.01 Flag-4