It shows that you are unregistered. Please register with us by clicking Here
![]() |
|
![]() |
![]() | Register - FAQ - Today's Posts - New Posts - Support - Search | ![]() |
|
|
#1 (permalink) |
|
Junior Member
Join Date: Jul 2006
Age: 33
Posts: 27
|
Hi everybody! I was trying to tune some tables in my Oracle 7.3.15 database yesterday and I decided to modify one table that seemed to have chained rows. So, after surfing for a while looking for docs, I backed up that table, truncated it and reinserted all the rows that I had backed up. Now I have my table restored, but table access is extremely slow. Reports, which used to generate in just 2 minutes they just won’t come out for hours. The table is about 30000 rows with archers, numbers and dates. There are some indexes too, but they seem all right. Can anybody, please tell me what’s going on? Thank you
jason |
|
|
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Forum slow down? | scoooooty | All Things General | 8 | 09-07-2006 06:06 PM |
| Slow today | lisah746 | All Things General | 7 | 09-01-2006 02:27 AM |
| Why is XMLSerializer so slow? | agaba175 | .NET | 0 | 08-01-2006 04:20 PM |
| viewstate slow down performance? | Tom Tom | .NET | 0 | 07-11-2006 11:57 PM |