Re: Speeding up my SQL statement

g!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Paul Ripke [mailto:[EMAIL PROTECTED] Sent: Friday, July 02, 2004 02:20 To: [EMAIL PROTECTED] Subject: Re: Speeding up my SQL statement This is untested, but may be faster: select node_name, filespace_name,

Re: Speeding up my SQL statement

all for helping!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Paul Ripke [mailto:[EMAIL PROTECTED] Sent: Friday, July 02, 2004 02:20 To: [EMAIL PROTECTED] Subject: Re: Speeding up my SQL statement This is untested, but may be faster: select node_na

Re: Speeding up my SQL statement

" -(me) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Tuesday, June 29, 2004 8:03 AM To: [EMAIL PROTECTED] Subject: Re: Speeding up my SQL statement I thought about that, but would that help? If TSM still has to scan eve

Re: Speeding up my SQL statement

ehalf Of Richard Sims Sent: Tuesday, June 29, 2004 8:03 AM To: [EMAIL PROTECTED] Subject: Re: Speeding up my SQL statement >I thought about that, but would that help? If TSM still has to scan every >object for a match, it wouldn't help much... That's the problem, I don't know

Re: Speeding up my SQL statement

y, June 29, 2004 14:03 To: [EMAIL PROTECTED] Subject: Re: Speeding up my SQL statement >I thought about that, but would that help? If TSM still has to scan every >object for a match, it wouldn't help much... That's the problem, I don't know >how SQL works... Eric - Your pe

Re: Speeding up my SQL statement

>I thought about that, but would that help? If TSM still has to scan every >object for a match, it wouldn't help much... That's the problem, I don't know >how SQL works... Eric - Your perception is correct: if you scan a table, it will traverse the whole thing. Whereas the Backups table is

Re: Speeding up my SQL statement

ene,VEVEY,GLOBE Center CSC [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 13:21 To: [EMAIL PROTECTED] Subject: Re: Speeding up my SQL statement hi Eric, you could add node_name like '%ORC' to the where clause... best regards, René LAMBELET NESTEC

Re: Speeding up my SQL statement

hi Eric, you could add node_name like '%ORC' to the where clause... best regards, René LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center SD/ESN Av. Nestlé 55 CH-1800 Veve