what is the difference if we create index (at time create table or after insert data into that table ?)

Question

Post reply

what is the difference if we create index (at time create table or after insert data into that table ?)

kbhanu15

SSCarpal Tunnel

Points: 4493
More actions
March 26, 2014 at 12:30 am

#284930

hi all,
can you explain me the effect of the below questions ?
what is the difference if we create index (at time create table or after insert data into that table ?)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Cody Konior SSCarpal Tunnel Points: 4827 More actions · Answer 1

Sounds like someone's homework. What do you think the answer is?

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

It depends. What is the size of data?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 3

Heh... I'll second the "It Depends" aspect.

What Recovery Model is the database in?

What kind of index are you trying to build?

How many rows are you inserting in the initial batch of rows?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 4

+1 Jeff

Ultimately you need to test and get an idea of when it's quicker. It often does depend on how much data, and your disk I/O. Are you creating a temp table and creating the index afterwards (i.e on the fly) or are you referring to a "typical" table that could have millions of rows over time?

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

free_mascot One Orange Chip Points: 27169 More actions · Answer 5

kbhanu15 (3/26/2014)
what is the difference if we create index (at time create table or after insert data into that table ?)

Is this interview question?

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."