Performance of databse management systems relates to low response time with maximum throughput. Therefore, it is necessary to adopt such scheme which can execute the workload with fewer time. Such scheme wich can also helpful in parallel query processing or can process batch queries simultenously, which can be used in developing the query mixes. Therefore, this research proposes a novel scheduler named as ‘Ascheduler’. This proposed scheduler assigns the priority using modified MQI (Multiple Query Interaction) to each query on the basis of its resource usage for the completion of its execution which is coming for the developing the query mixes. The developed the query mixes by the proposed scheduler is categorized into best, good, moderate and bad quer mixes. This categorization of the query mixes is on the basis of resource utilization and their response time. It also keeps avoidance of developing bad query mixes by using previously developed query mixes response time and resource utilization by keeping record of priority of each query used in query mix as well as an individual query. The novel proposed scheduler named ‘Ascheduler’ also reduces the overall execution time of workload and perforem better in the other performace metrices like response time, categorization accuracy and interaction improvement score from
the existing schedulers like Forst Come First Serve (FCFS) and Shortest Job First (SJF).