Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import data from a Source database which does not have the indexes. Expand / Collapse
Author
Message
Posted Monday, September 17, 2012 2:46 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 415, Visits: 1,603
Hi,

I am importing whole data (with out any where condition) from a database, and that database tables donot have any indexes.

Is there any impact on performance of the script if tables don't have indexes?
As per my knowledge, if the table have clustered index it will be good. because the data pages will in an order so fetching will be good.

Please correct me if i am wrong.

Thank you,


Post #1360029
Posted Monday, September 17, 2012 2:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 3, 2013 12:38 AM
Points: 91, Visits: 77
It depends on the size of your database, number of tables and rows in them.

*******
Sudhakar
Post #1360033
Posted Monday, September 17, 2012 6:21 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 415, Visits: 1,603
What is the base line for that? If my table is having few millions of records (ex: 20 millions) then what is best approach.

Obviously we have to create index on source tables only right? if we are not using any where clause how the index will be beneficial?



Post #1360144
Posted Monday, September 17, 2012 9:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 1,001, Visits: 13,532
If there is no where/order by clause in your query then indexes are unlikely to help you.
Post #1360296
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse