InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 21:50:13 GMT20http://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspx[quote][b]Bhuvnesh (1/24/2013)[/b][hr][quote][b]Koen Verbeeck (1/24/2013)[/b][hr][url=http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/do-not-disable-foreign-keys]Do not disable foreign keys[/url][/quote] Any other reference ?[/quote]Maybe. I'm sure Google can help you out ;-)Thu, 24 Jan 2013 00:58:52 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspx[quote][b]Koen Verbeeck (1/24/2013)[/b][hr][url=http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/do-not-disable-foreign-keys]Do not disable foreign keys[/url][/quote] Any other reference ?Thu, 24 Jan 2013 00:56:18 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspx[quote][b]debanjan.ray (1/24/2013)[/b][hr]That table contains only 1lac rows. Table PK:Table_sr_key, table_eff_strt_dtTable FK(10 Fks like same structure): PRD_SR_KEY, EFF_STRT_DTREFERENCES Product (PRD_SR_KEY, EFF_STRT_DT)Table is refernced by more than 20 table.[/quote]This is primarily a English-speaking site, so 95% of the people here don't know what you mean with lac (or lakh). Also read the following article about keeping the integrity of your database when deleting rows in a table referenced by FKs:[url=http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/do-not-disable-foreign-keys]Do not disable foreign keys[/url]Thu, 24 Jan 2013 00:43:12 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspxNo.. On delete cascade option is not there with FK....Thu, 24 Jan 2013 00:39:45 GMTdebanjan.rayhttp://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspxdo FK are with "[b]on cascade delete[/b]" option ? Thu, 24 Jan 2013 00:35:06 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspxstill you havent posted what all i asked anyways i will suggest you to take [b]batch approach[/b] for "Deletion" . and i dont think "periodic statistics updation will help you much HERE "Thu, 24 Jan 2013 00:34:10 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspxThat table contains only 1lac rows. Table PK:Table_sr_key, table_eff_strt_dtTable FK(10 Fks like same structure): PRD_SR_KEY, EFF_STRT_DTREFERENCES Product (PRD_SR_KEY, EFF_STRT_DT)Table is refernced by more than 20 table.Thu, 24 Jan 2013 00:31:09 GMTdebanjan.rayhttp://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspxMaybe you should create a job to automatically update your statistics, since they're clearly out of date.Thu, 24 Jan 2013 00:22:22 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspx[quote][b]debanjan.ray (1/24/2013)[/b][hr]One of simple delete query is taking more than 10hrs to execute. There are more than 12 foreign keys dependent on that table. Query is like this, Delete from Some_Table where table_sr_key !=-99 and sector_id=@some_code [/quote] Two questions :How much data it contains ? and do FK are with "on cascade delete" option ? Also post table defintion along with index definitionThu, 24 Jan 2013 00:13:25 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1410924-149-1.aspxHi All, One of simple delete query is taking more than 10hrs to execute. There are more than 12 foreign keys dependent on that table. Query is like this, Delete from Some_Table where table_sr_key !=-99 and sector_id=@some_code But if we execute the same query after updating the statistics of the table then the query get executed in few minutes. Please help me how me handle this issue so that those query will execute without any manual intervention. Thanks in advance, DebanjanThu, 24 Jan 2013 00:03:59 GMTdebanjan.ray