As I know, there are 2 types of queries (predicted and ad-hoc
queries) in Data Warehouse environment. Ad-hoc queries are the majority.
By looking at the history of query profile of each user at specific
time, is it possible for DBA to predict ad-hoc queries (or the quries
that are likely to be ad-hoc)?
Any suggestion would be appreciated.
Thanks in advance,