Re: [SQL] SQL Technique Question

2006-06-15 Thread Michael Glaesemann
[Please quote responsibly. There was no need to quote my entire message back to the list.] On Jun 16, 2006, at 7:15 , <[EMAIL PROTECTED]> wrote: i need to become mor familiar with views. if i use views, will i substantially impair performance? Short answer: maybe, maybe not Long answer: b

Re: [SQL] SQL Technique Question

2006-06-15 Thread operationsengineer1
> On Thu, Jun 15, 2006 at 01:59:22PM -0700, > [EMAIL PROTECTED] wrote: > > > > is it a good practice to leave this included in > the > > queries, as is, or should i factor it out somehow? > if > > i should factor it, how do i do so? > > If what you're saying is that these additional > criteria a

Re: [SQL] SQL Technique Question

2006-06-15 Thread operationsengineer1
> > On Jun 16, 2006, at 5:59 , > <[EMAIL PROTECTED]> wrote: > > > i frequently join certain tables together in > various > > tables. > > > > view the following link for an example: > > > > http://www.rafb.net/paste/results/mBvzn950.html > > > > is it a good practice to leave this included in > th

Re: [SQL] SQL Technique Question

2006-06-15 Thread Michael Glaesemann
On Jun 16, 2006, at 5:59 , <[EMAIL PROTECTED]> wrote: i frequently join certain tables together in various tables. view the following link for an example: http://www.rafb.net/paste/results/mBvzn950.html is it a good practice to leave this included in the queries, as is, or should i factor it

Re: [SQL] SQL Technique Question

2006-06-15 Thread Rod Taylor
On Thu, 2006-06-15 at 13:59 -0700, [EMAIL PROTECTED] wrote: > i frequently join certain tables together in various > tables. > is it a good practice to leave this included in the > queries, as is, or should i factor it out somehow? if > i should factor it, how do i do so? Future proofing selects

Re: [SQL] SQL Technique Question

2006-06-15 Thread Andrew Sullivan
On Thu, Jun 15, 2006 at 01:59:22PM -0700, [EMAIL PROTECTED] wrote: > > is it a good practice to leave this included in the > queries, as is, or should i factor it out somehow? if > i should factor it, how do i do so? If what you're saying is that these additional criteria are redundant, then it'

[SQL] SQL Technique Question

2006-06-15 Thread operationsengineer1
i frequently join certain tables together in various tables. view the following link for an example: http://www.rafb.net/paste/results/mBvzn950.html is it a good practice to leave this included in the queries, as is, or should i factor it out somehow? if i should factor it, how do i do so? tia