I have one SYBASE ASE 16.0 Database running having 5 tempdb and each of them of 500MB.
Now suppose one query is trying to allocate 600 MB tempdb to execute it, in this scenario what will be the result:
Will the query be aborted as each tempdb is of 500MB and query is needed 600MB ?
Or will it take 2 tempdb to execute it successfully?
Please help me if you know the answer.