Velayutham, Prakash wrote: % Hi Michael, % % Here is a detailed response from our DBA. % % If you remove the first_rows hint from both the old query , the number of blocks retrieved is the same at 5826 versus 108981. This might decrease the usage of TEMP space. We can try it and monitor. ...
I observed the same behaviour so thank you for confirmation. I commited a change which removed first_row hint from current queries to spacewlk master branch (commit f8c71ef4ae14db95ba3650cac3b55f1f9f153c6b). Thank you. Regards, -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
