RE: Create Table performance problem

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Wed, 23 May 2001 14:09:06 -0700
Message-ID: <F001.0030C47C.20010523113131@fatcity.com>

AFAIK the Select in a Create Table statement is treated exactly the same as if it were issued by itself. The Optimizer will decide whether or not indexes on the Selected tables are used.

Is the Table being created in a tablespace on the same drive as the source table(s) or, worse, on the drive with the temp tablespace or rollback segment(s)? You could be experiencing disk contention.

Jack

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
japplewhite_at_inetprofit.com
(512)327-9068

-----Original Message-----
cemail_at_sprintmail.com
Sent: Wednesday, May 23, 2001 1:05 PM
To: Multiple recipients of list ORACLE-L

Does CREATE TABLE AS SELECT ..... still use indexes or are the indexes disregarded if the select is issued in combination with a create table?

Oracle 8.0.5, optimizer is CHOOSE.

We are having a performance problem when trying to use create table as select.

Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: cemail_at_sprintmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: japplewhite_at_inetprofit.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Wed May 23 2001 - 16:09:06 CDT