Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: "rename" and "create table x as select *" questions
Thank you all for replying. Jurij Modic took the time to provide examples.
Thank you.
Ying-fen Hu
Ying-fen Hu wrote:
> Dear Oracle Gurus,
>
> I have two questions:
>
> 1. Will "rename" take a long time if the table is large? What are
> involved in the rename process?
> 2. Will "create table x as select * from table y where 1=2;" take a
> long time if table y is very large (8 million rows)? I think it will.
> Although, this statement will create the structure only and no data are
> transferred to table y, the "where" clause will go through the usual SQL
> process. Therefore, if the table is large (millions of rows), the
> statement will take longer than if the table is smaller (hundreds of
> rows). Is it correct? I'd like to know what's happening behind the
> statement.
>
> Thank you in advance for your reply. For reply, please also e-mail to
> huy_at_ncr.disa.mil.
>
> Ying-fen Hu
Received on Wed Jun 02 1999 - 19:16:21 CDT
![]() |
![]() |