Re: How to Choose Method to Transfer Data from Production to Reporting database
- From: "JT" <someone@xxxxxxxxxxxxx>
- Date: Fri, 8 Jul 2005 09:04:44 -0400
Actually, I would expect the query portion to run within a few seconds, if
the two tables are joined using an indexed column.
"Resant" <resant_v@xxxxxxxxx> wrote in message
news:1120784708.699397.48280@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I understand what you mean, but I've hundred records, so using that
> query, I think is still have slow performance.
>
.
- References:
- Prev by Date: Re: Create table, remove records?
- Next by Date: Re: SQL Server on more than 4 CPUs??
- Previous by thread: Re: How to Choose Method to Transfer Data from Production to Reporting database
- Next by thread: Normalized Data base
- Index(es):
Loading