Re: performance of Insert with Partitioned View

From: BP Margolin (bpmargo@attglobal.net)
Date: 04/24/03 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Wed, 23 Apr 2003 23:25:33 -0400

TNL,

As documented in the SQL Server Books Online, partitioned views require UNION ALL's. Using just UNION does not create a partitioned view.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"TNL" <le.nhan@freenet.de> wrote in message news:ed#AssgCDHA.33548@TK2MSFTNGP10.phx.gbl...
> I am trying to insert new Records in different Database on different Server
> with a Partitioned View, but the perfomance is very bad.
>
> The partitioned View: MyPVIEW
> SELECT * FROM server1.myDB.myTable
> UNION
> SELECT * FROM server2.myDB.myTable
> UNION
> SELECT * FROM server3.myDB.myTable
>
> The Job:
> Insert into MyPVIEW
> SELECT * FROM Temp
>
> Temp is a Table on the local server, it hat about 300.000 records.
>
> How can I improve the performance?
>
>

Relevant Pages

  • Re: Cannot post string "union select" php form
    ... i am trying to figure it out why i cannot post string "union select" ... every time i try to post data which content union and select .. ... i guess the server i am using has some kind of filter and if a post ... Do you have some PHP code showing this? ...
    (comp.lang.php)
  • Re: Nochmal SP mit Records-Set Rückgabe.
    ... daß MySQL derart kapott ist. ... Server neu gestartet wird oder ein berechtigter Benutzer selbige ... und auch UNION ALL wirft einen ...
    (de.comp.datenbanken.mysql)
  • Re: Cannot post string "union select" php form
    ... i am trying to figure it out why i cannot post string "union select" ... every time i try to post data which content union and select .. ... i guess the server i am using has some kind of filter and if a post ... so i think the problem is with string which i am posting ... ...
    (comp.lang.php)
  • Re: Cannot post string "union select" php form
    ... i am trying to figure it out why i cannot post string "union select" ... every time i try to post data which content union and select .. ... i guess the server i am using has some kind of filter and if a post ... Do you have some PHP code showing this? ...
    (comp.lang.php)
  • Re: Combining Queries
    ... you probably want a UNION or UNION ALL query. ... > FROM oehistdetail') AS wcw, ... > FROM Customers') AS Custs ... >Server is by ...
    (microsoft.public.sqlserver.programming)