Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Time Out Error
- Thread starter myrcmstr
- Start date
Make sure you have temp table space creation access in the database and if so, you have ENOUGH space to store it. Users in my client site have 200GB spaces and they spool out.
Try to restrict the amount of data you want to display.
Check your SQL for cross joins and make sure 'fail on cartesian join' is turned on in your VLDB.
Make sure you aren't comparing two huge fact tables.
Anyone got any other ideas?
Try to restrict the amount of data you want to display.
Check your SQL for cross joins and make sure 'fail on cartesian join' is turned on in your VLDB.
Make sure you aren't comparing two huge fact tables.
Anyone got any other ideas?
- Status
Similar threads
- Locked
- Question