Re: faster joins
From: Kevin Spencer (kspencer_at_takempis.com)
Date: 06/25/04
- Next message: Cindy: "Assigned value to user control during Page_Load"
- Previous message: Rukmal Fernando: "Displaying File name on a fetcher page"
- In reply to: SKG: "Re: faster joins"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 25 Jun 2004 08:12:47 -0400
A Distributed query is a query which involves databases on different
servers.
-- HTH, Kevin Spencer .Net Developer Microsoft MVP Big things are made up of lots of little things. "SKG" <sunil_godiyal@yahoo.com> wrote in message news:#i3kYHjWEHA.1888@TK2MSFTNGP11.phx.gbl... > Thanks!! Kevin. With in the same server will the query be treated as > distributed query. > "Kevin Spencer" <kspencer@takempis.com> wrote in message > news:%23CjNbniWEHA.3972@TK2MSFTNGP12.phx.gbl... > > As long as they are on the same SQL Server, the JOIN would be just as > fast. > > Distributed queries are expensive. > > > > Kevin > > "SKG" <sunil_godiyal@yahoo.com> wrote in message > > news:##W7sbiWEHA.204@TK2MSFTNGP10.phx.gbl... > > > I have two databases with in same sql server. > > > I want to know whether a join of two tables with in same database is > > faster > > > or than > > > join of tables across two databases > > > > > > Thanks!!! > > > > > > > > > > > >
- Next message: Cindy: "Assigned value to user control during Page_Load"
- Previous message: Rukmal Fernando: "Displaying File name on a fetcher page"
- In reply to: SKG: "Re: faster joins"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
