Home » Other » General » Which one is best
Which one is best [message #198676] Wed, 18 October 2006 04:08 Go to next message
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
Senior Member
Hi Friends,

I have one doubt,,,,pls clear it

I have more than one crore datas in a table.

I want to add one column in a table ( 'Defalut' as defalut)

Which method is best..

1.Creating a new table and copying all the data

2. adding one more column.

Thanx and regards
Selva
Re: Which one is best [message #198680 is a reply to message #198676] Wed, 18 October 2006 04:21 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
selvakumar_82 wrote on Wed, 18 October 2006 11:08
I have more than one crore datas in a table.
What's a crore? 2 apples and one banana?

MHE
Re: Which one is best [message #198691 is a reply to message #198680] Wed, 18 October 2006 04:40 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Crore = Croatian records http://www.orafaq.com/forum/fa/1587/0/

Wikipedia says that "30 million = (3 crores)". So, 1 crore would be 10 millions, I guess.
Re: Which one is best [message #198710 is a reply to message #198691] Wed, 18 October 2006 05:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1 lakh (or lak/lack depending on the mood of poster) = 100,000 (One hundred thousand).
100 lakhs = 1 crore = 10 millions

Using 'hundred thousands/millions/billions' is not a common practise in India (until very recent times and used only among the IT/Finance people). Lakh/Crore is even used officially and taught along with English/all local languages. OP is not the only person to be blamed for this confusion Smile
Re: Which one is best [message #198738 is a reply to message #198710] Wed, 18 October 2006 07:04 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I should have known...I'm to blame too: I was too lazy to look it up in Wikipedia Embarassed.

On topic: what do you reckon: CTAS or ALTER TABLE? What is the fastest.

MHE

[Updated on: Wed, 18 October 2006 07:04]

Report message to a moderator

Re: Which one is best [message #198790 is a reply to message #198738] Wed, 18 October 2006 09:40 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I'm to blame too: I was too lazy to look it up in Wikipedia Embarassed
Nope. I don't think so.
It is not your(our) responsibility to decipher a local slang.
It is the responsibility of the OP to post in international standards in an *international* web forum.
In many cases, folks were just unware of that and when pointed would get corrected.
So it is nobodys fault.

Coming back to the thread,
>>CTAS or ALTER TABLE? What is the fastest.
As usual it depends.
10 million records is kinda mid-average.
A simple ALTER TABLE add column may be enough.

It depends on the usage of the column ( or how to update the column with what value?).
In this case some default value is used on the new column and that would be very painful (because
that will update every row).

In that case a new table would be better.

create a new_table from old_table with just the structure (no data).
Add the new_column to the new_table (with default specifications).
insert into new_table from old_table along with APPEND hint.
drop the old_table. rename new_table to old_table.
recreate indexes/constraints. collect stats


[Updated on: Thu, 19 October 2006 09:16]

Report message to a moderator

Previous Topic: Oracle Express Edition
Next Topic: RDBMS&ORDBMS
Goto Forum:
  


Current Time: Wed Dec 07 22:15:15 CST 2016

Total time taken to generate the page: 0.09010 seconds