Post reply

Import data from a Source database which does not have the indexes.

  • September 17, 2012 at 2:46 am

    #393194

    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,

    🙂

  • September 17, 2012 at 2:56 am

    #1538447

    It depends on the size of your database, number of tables and rows in them.

    *******:cool:
    Sudhakar

  • September 17, 2012 at 6:21 am

    #1538552

    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?

    🙂

  • September 17, 2012 at 9:52 am

    #1538687

    If there is no where/order by clause in your query then indexes are unlikely to help you.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply