• 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?

    🙂