Home » RDBMS Server » Server Administration » Locking occurring when performing SELECT with ORDER BY
Locking occurring when performing SELECT with ORDER BY [message #61994] |
Wed, 16 June 2004 13:53  |
Matthew Sedares
Messages: 2 Registered: June 2004
|
Junior Member |
|
|
Hello,
On two schemas on a particular 8.1.7 DB, my users are getting locked out whenever they run a select statement with an "order by" clause.� This only occurs on two schemas on the database, and there are a total of 8 schemas.�
I have tried recreating indexes, but that did not work.� To verify, I am failing on�ALL statements with the ORDER BY statement, not ust the ones�which use an index.� In addition I tried reanalyzing statictics on all�tables and indexes�for the schemas with the issue.� Does anybod have any idea what could be causing this and wehat could be done to repaiur this?
Many, many thanks, to anyone that could help.
Matt
|
|
|
|
|
Goto Forum:
Current Time: Fri May 02 09:31:34 CDT 2025
|