Refactor dsmetadata queries to fetch workload and container info, enhancing the performance

[shreyabiradar07]

Describe the feature

Remove redundant WORKLOAD_INFO_QUERY and instead use CONTAINER_INFO_QUERY as the common query to fetch both workload and container metadata.

Examples or references

Add any examples or references to understand it better

Suggest a solution

Remove redundant WORKLOAD_INFO_QUERY and instead use CONTAINER_INFO_QUERY and refactor import metadata logic to accommodate the query updates.

Additional Context

As we have CONTAINER_INFO_QUERY which has both container and workload details it is redundant to run WORKLOAD_INFO_QUERY and also we can avoid running an extra for loop for workload -

autotune/src/main/java/com/autotune/database/helper/DBHelpers.java

Line 1019 in 4c3195d

for (DataSourceWorkload dataSourceWorkload : dataSourceNamespace.getDataSourceWorkloadHashMap().values()) {

This can help in reducing the time taken to get the datasource details and also avoids redundancy.