I appreciate your insight. I would like to get more infromation on it. Can you direct me to the resources that will help me to understand gathering and analyzing I/O...

What do you...

Cool.. Worked for me. Thank you.

Temp tables are created in TempDB Database and require more IO resources and locking. It maintains statistics and allows explicit indexing. We can use ‘into clause’ to create...

Mazharuddin - Thank you for your insight.

rbarryyoung - I am starting to read the document but there are a lot of information on it. I am a slow reader so...

Can we work directly from production database or need to make copy of it? I found out that we are getting rid of oracle and we don't have development environment....

db1 and db2 both are mapped to user.

Thanks alot

Thank you for your response.

I have worked as sql server developer in the past but not much knowledge of Oracle. Can you tell me how much you need to know...

Thank you for your insight. That makes sense but I am trying to create a covering index which will include all the columns in select list, join condition and where...

I have to update.

this is the structure of table to be updated

...

Thank you, Steve. I was able to get index seek with hints which I didn't want to do. But whatever works is fine for now.