| Author |
Topic |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2009-06-09 : 16:22:30
|
| i am trying to drop an index in the size of 2180520kbit's running for 7.5 hours .... any idea why it take so much time?Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-09 : 16:33:07
|
Is the index clustered or non-clustered?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2009-06-09 : 16:39:31
|
| yes - is that the reason? if yes then when? can i do something to improve the time?Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2009-06-10 : 04:05:20
|
| i have found the problem.once i have removed the Primary KEY everything went in seconds.can any one explain why?ThanksPelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-10 : 04:10:32
|
Yes.All non-clustered indexes contains a pointer to the clustered index, if such exists.When removing the clustered index, all non-clustered indexes has to change the record pointer to another pointer.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2009-06-10 : 04:57:27
|
| okwhy after i deleted aall the indexe's i still see that it holds a space of ~1GB?can i clean that to?Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2009-06-10 : 14:37:45
|
| nopeIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
droping index