Re: Discussing 3 different strategies for deleting from multiple tables



> Your method 4 seems like my method 2?

Very similar.
If you are using SQL Server, you should be able look at the plan generated
in Query Analyser and I think you will find that Method 2/4 is more
efficient than 1.

Stephen Howe


.



Relevant Pages

  • Issues in SQL7 or 2000 setup?
    ... I am just trying to put a plan together to see what issues that I might see ... when setting up a new SQL server. ... RAM? ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)
  • Re: Slow UPDATE and DELETE on SQL Server 2000
    ... databases: one on the new machine and one on the old machine (by the ... The plan from the old machine was more complex and has PARALLELISM ... > wrong with the SQL Server installation and unlikely that there are sub-system ... > linked-server driver parameters are not properly set. ...
    (microsoft.public.sqlserver.server)
  • Re: insert..select
    ... Parameter sniffing. ... > The execution plan is vastly different. ... trigger on the target table. ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Coordinating multiple projects
    ... show when something in another schedule is needed in yours. ... > should not affect any successor until the successor plan is calculated. ... > btw Why insert the additional milestone when the macro could reference the ... Is this a problem with MS-Project or SQL server? ...
    (microsoft.public.project)