attempting to tune poor performing SQL
Please forgive the silly questions but I am not a DBA but have been tasked with looking at this.
What I have is a database running on a virtual machine with 4 cores and 6 gig of memory. This is a windows machine running windows 7
The SQL that is having the most issues are using views that join multiple tables. The tables and views exist in a single schema that is "rebuilt" every morning, the process drops each table and recreates it using a create/select. The select is using tables from a database link that is connected to the production database.
What I have is a database running on a virtual machine with 4 cores and 6 gig of memory. This is a windows machine running windows 7
The SQL that is having the most issues are using views that join multiple tables. The tables and views exist in a single schema that is "rebuilt" every morning, the process drops each table and recreates it using a create/select. The select is using tables from a database link that is connected to the production database.
0