var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Delete opreation is taking too much time
In my database I wrote a simple sql delete command like
delete from market_type where name='new market'
The command is taking too much time while edit and select command with same 'where' condition taking very short time.
Can anyone help me on this issue?????
How many Foreign Keys are defined on that table? FK's can make DELETEs crawl.
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages