hI

WHAT I WANT TO KNOW EXACTLY IS

HERE IS MY QUESTION ,SINCE SOME ONE ASKED ME IN AN INTERVIEW WERE DO U SPECIFY THE TEMPORARY TABLESPACE FOR SORTING OPERATIONS OF A LONG-RUNNING QUERY .


I KNOW THAT TEMP TABLESPACE IS CREATED FOR SORTING OPERATIONS ,IF I AM EXECUTING A BIG QUERY WERE MY TABEL SPACE IS NOT SUFFICIENT AND IT AFFECTS OTHER USERS TOO .iF U KNOW PRIORLY THE QUERY IS GOING TO BE LONG WERE WAHICH PARAMETER WE CHANGE IT

THANKS FOR THE INFN

THANKS
LNREDDY