Not sure what I'd expect, but I get no execution plan for the statement below. Nor is there any indication of progress just an uncomfortable wait.

Roy Lambert

CREATE TABLE xTable
AS
SELECT FALSE AS _Selected,
_fkContacts,
_fkCompanies,
_Surname,
_Forename,
(_Forename+' '+_Surname) AS _xContactName,
IF(_EMail IS NOT NULL,_EMail,_HomeEMail) AS _xEMail,
_EMail,
_HomeEMail,
_JobTitle,
_Name AS _CompanyName,
_Left,
_NoEshots
FROM "NLH-Live".Contacts T0
JOIN "NLH-Live".Career ON Career._fkContacts = _ID
JOIN "NLH-Live".Companies ON Companies._ID = Career._fkCompanies
WITH DATA

Roy,

<< Not sure what I'd expect, but I get no execution plan for the statement
below. Nor is there any indication of progress just an uncomfortable wait.
>>

You won't get either since ultimately the operation is a CREATE TABLE, not a
SELECT.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Execution plan I can live without since I can use just the select to create one and see how its doing but I would like a progress indicator for the with data bit which can take a while so it would be nice to let people know there's something happening.

Roy Lambert

Roy,

<< Execution plan I can live without since I can use just the select to
create one and see how its doing but I would like a progress indicator for
the with data bit which can take a while so it would be nice to let people
know there's something happening. >>

I'll see what I can do, but the two are in different categories of statement
execution, so it may not work.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Any news on this before I start splitting up my memory table CREATE AS WITH DATA into a WITH NO DATA and a separate INSERT INTO?
Roy Lambert

Roy,

<< Any news on this before I start splitting up my memory table CREATE AS
WITH DATA into a WITH NO DATA and a separate INSERT INTO? >>

New features only come out for minor releases, and right now I can't say
when the next minor release will be.  There's a lot of new features on the
list currently, and I'm thinking that it's getting close to EDB v2 time.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< Any news on this before I start splitting up my memory table CREATE AS
>WITH DATA into a WITH NO DATA and a separate INSERT INTO? >>
>
>New features only come out for minor releases, and right now I can't say
>when the next minor release will be. There's a lot of new features on the
>list currently, and I'm thinking that it's getting close to EDB v2 time.

Ignoring the timetable is it liable to happen, I know you had some reservations? If so I'll leave the statements alone, if not I'll start splitting them.

Roy Lambert

Roy,

<< Ignoring the timetable is it liable to happen, I know you had some
reservations? If so I'll leave the statements alone, if not I'll start
splitting them. >>

I should be able to make an exception for the CREATE TABLE statement.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


OK, if its not going to happen let me know and I'll split the statements up. Its a simple cut'n'paste so no big deal.

Roy Lambert