I could just try this to see, but I'm feeling lazy and someone probably
knows the answer.

If I write a query with one or more common table expressions to which I
don't actually refer in the query, do they just get pruned off or do
they get executed regardless?

--
Roy

UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012.
The latest information is available from www.uk-iua.org.uk.

On Jan 4, 2012, at 2:14 PM, Roy Hann wrote:

I'm guessing they get pruned off, but I'd have to try it to find out.
I'm lazy too.

I trust your holidays were merry ... ours were generally quite nice.

Karl

Example query?

Marty

-----Original Message-----
From: Roy Hann [mailto:specially (AT) processed (DOT) almost.meat]
Sent: 04 January 2012 19:14
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] What happens to unused common table expressions?

I could just try this to see, but I'm feeling lazy and someone probably
knows the answer.

If I write a query with one or more common table expressions to which I
don't actually refer in the query, do they just get pruned off or do
they get executed regardless?

--
Roy

UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012.
The latest information is available from www.uk-iua.org.uk.


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres