Re: [SQL] optimizing a query over tree-like structure

2008-09-30 Thread Oliveiros Cristina
or P, just with an F. Which info is to be retrieved, exactly in this case ? Best, Oliveiros - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Tuesday, September 30, 2008 3:24 PM Subject: Re: [SQL] optimizing a query over tree-like structure another idea i just got, to dec

Re: [SQL] optimizing a query over tree-like structure

2008-09-30 Thread az
which, from my own > experience, I guess it has tendency to be slow... > > Best, > > Oliveiros > > - Original Message - > From: <[EMAIL PROTECTED]> > To: > Sent: Tuesday, September 30, 2008 9:32 AM > Subject: [SQL] optimizing a query over tree-like structure > &

Re: [SQL] optimizing a query over tree-like structure

2008-09-30 Thread Oliveiros Cristina
2008 9:32 AM Subject: [SQL] optimizing a query over tree-like structure hi. sorry for the vague syntax used below, but the query is huge so i've tried to present it in simple terms. And sorry if i'm doing obviously stupid things, i have lots of years programming behind me but NO sql i

[SQL] optimizing a query over tree-like structure

2008-09-30 Thread az
hi. sorry for the vague syntax used below, but the query is huge so i've tried to present it in simple terms. And sorry if i'm doing obviously stupid things, i have lots of years programming behind me but NO sql involved. i have a somewhat tree-like structure of objects that link to each other