Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 7 of 7 total |
CREATE TABLE AS |
Thu, May 31 2007 8:43 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | I've just being doing some tests of this and I must say I'm pretty impressed by the speed. Two things
1. Can we have a time taken indicator on the SQL page for the database - I'd prefer something better than me going 1 and 2 and 3 2. More importantly WITH DATA ignores any ORDER BY clause in the select statement. Is this what its meant to do? If so I need to create indices (oh the pain of no scripts and also change the way I handle changing sorting for the grid. Roy Lambert |
Thu, May 31 2007 3:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< 1. Can we have a time taken indicator on the SQL page for the database - I'd prefer something better than me going 1 and 2 and 3 >> If you're referring specifically to the CREATE TABLE AS, then yes, I'll see what I can do. << 2. More importantly WITH DATA ignores any ORDER BY clause in the select statement. Is this what its meant to do? >> Sure, you're creating a table, and an ORDER BY doesn't really have any bearing on this. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, May 31 2007 4:25 PM | Permanent Link |
"Ole Willy Tuv" | Tim,
<<< 2. More importantly WITH DATA ignores any ORDER BY clause in the select statement. Is this what its meant to do? >>> << Sure, you're creating a table, and an ORDER BY doesn't really have any bearing on this. >> I'm not sure if I agree with you on this one One thing is that the ORDER BY clause isn't officially supported by the <query expression> which is the basis of the CREATE TABLE AS construct. However, as long as EDB support the ORDER BY clause as an extention to the <query expression>, I think it should have the expected effect. Ole Willy Tuv |
Fri, Jun 1 2007 3:13 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< 1. Can we have a time taken indicator on the SQL page for the database - >I'd prefer something better than me going 1 and 2 and 3 >> > >If you're referring specifically to the CREATE TABLE AS, then yes, I'll see >what I can do. Basically I'd like to see the time taken for any sql statement of any of the pages in EDBMan. I appreciate that for a lot of operations the time taken will be a big fat 0, but on the other occasions it could be useful. Roy Lambert |
Fri, Jun 1 2007 3:18 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< 2. More importantly WITH DATA ignores any ORDER BY clause in the select >statement. Is this what its meant to do? >> > >Sure, you're creating a table, and an ORDER BY doesn't really have any >bearing on this. Which other keywords aren't supported eg DISTINCT, GROUP BY? Roy Lambert |
Fri, Jun 1 2007 3:15 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ole,
<< I'm not sure if I agree with you on this one One thing is that the ORDER BY clause isn't officially supported by the <query expression> which is the basis of the CREATE TABLE AS construct. However, as long as EDB support the ORDER BY clause as an extention to the <query expression>, I think it should have the expected effect. >> I understand. I kept in the ORDER BY support because it does have one "effect" - the index created for the ORDER BY can be used for optimizing filters/queries on the created table. It's just not visible at all. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jun 1 2007 3:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Which other keywords aren't supported eg DISTINCT, GROUP BY? >> All of them are supported. The only distinction is that indexes are used in EDB for sorting query result sets, and the ORDER BY index simply isn't visible in the created table. Therefore, it can't be selected as the active index, etc. when the table is later opened/viewed. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |