In our PICK database all of the sudden select/list/sort statements have become extremely slow in one particular file. At first I thought it was a file resize issue but I've resized the file and no luck. Any ideas or suggestions?
i.e SELECT <FILENAME> WITH LOAD.DATE = "TODAY"
This type of select would almost be instant and out of nowhere that will take over 5 minutes to actually process.
Any ideas will help.