Hi, We have a database with lots of DML operations everyday and as data grows we face the application running slow. So we have partitioned some...
Hi, I am using temp tables to replace some inner queries to speed up the performance. The table in inner query has around 12 lakh records. Will it...
Hi This query is taking long time to run...may be because it has lot of joins. I am new to tuning. Please guide me as where to start on it and what...
Separate names with a comma.