Re: [PERFORM] Help optimize view

2007-08-20 Thread Relyea, Mike
> From: Kevin Grittner [mailto:[EMAIL PROTECTED] > > First off, let's make sure we're optimizing the query you > really want to run. > AND binds tighter than OR, so as you have it written, it is > the same as: > > HAVING "PrintSamples"."MachineID" = 4741 > OR ( "PrintSamples"."Mach

[PERFORM] Terminology Question

2007-08-20 Thread Campbell, Lance
Terminology Question: If I use the following statement: I am backing up schema XYZ every 30 minutes. Does this statement imply that I am only backing up the definition of the data? Or does it mean that I am backing up the definition of the data and the data within the schema object? T

Re: [PERFORM] Terminology Question

2007-08-20 Thread Scott Marlowe
On 8/20/07, Campbell, Lance <[EMAIL PROTECTED]> wrote: > > Terminology Question: > > If I use the following statement: > > I am backing up schema XYZ every 30 minutes. > > Does this statement imply that I am only backing up the definition of the > data? Or does it mean that I am backing up the def

Re: [PERFORM] Terminology Question

2007-08-20 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Campbell, Lance wrote: > Terminology Question: > > If I use the following statement: > > > > I am backing up schema XYZ every 30 minutes. > > > > Does this statement imply that I am only backing up the definition of > the data? Or does it mea