Whether source should be indexed ?
This is a discussion on Whether source should be indexed ? within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> Hi, We are populating staging tables using DTS . We are indexing our staging tables after loading. Our question ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 06:05 PM
| ||||
| ||||
 Whether source should be indexed ? Hi, We are populating staging tables using DTS . We are indexing our staging tables after loading. Our question is whether do we have to index our source tables before loading ? How it will effect the performance ? Thanks      |
|
02-27-2008, 06:05 PM
| ||||
| ||||
| Re: Whether source should be indexed ? If your dts process is generally scanning all columns of all tables, without joins, or where clauses, then no, indexing won't help. But pretty much other than that, appropriate indexes will help the dts process.  Are you asking how they will affect performance of the DTS process - generally that will improve. Will it affect on-line? Could improve it, could make it worse. "Vee" <general@microsoft.com> wrote in message news:OIE2Wp8TDHA.560@TK2MSFTNGP10.phx.gbl... > Hi, > > We are populating staging tables using DTS . We are indexing our staging > tables after loading. Our question is whether do we have to index our source > tables before loading ? How it will effect the performance ? > > Thanks > > > > |
Linear Mode
