RE: Re: Resource for index

2003-10-15 Thread Stephane Faroult
Sorry for having made myself misunderstood. + 0 does, in your case, NOTHING AT ALL. Nothing bad, nothing good. You can keep it or remove it. A + 0 can do something when : 1) Put after the name of a number column, eg WHERE SAL + 0 = 2000 2) And if there is an index on this

RE: Re: Resource for index

2003-10-15 Thread Stephane Faroult
Sorry for having made myself misunderstood. + 0 does, in your case, NOTHING AT ALL. Nothing bad, nothing good. You can keep it or remove it. A + 0 can do something when : 1) Put after the name of a number column, eg WHERE SAL + 0 = 2000 2) And if there is an index on this

RE: Re: Resource for index

2003-10-15 Thread Eca
Stephane, Thank you very much for explanation.Now I understood the case.+0 is nothing at statment.It is used only for Oracle does not use de index.Very good.Best Regards.Eriovaldo - Mensagem Original De: "Stephane Faroult" [EMAIL PROTECTED]Para: "Multiple recipients of list