| query that blocks db processes [message #62844] |
Thu, 19 August 2004 00:45 |
Efrem
Messages: 6
Registered: August 2004
|
Junior Member |
|
|
Hello everybody
I have the following problem;
I make a simple select query with an almost big where condition (about 3000 condition in OR clause) and if the table as an index on the primary key the query never replies and block the oracle processes, while if I delete the index the query replies within 30 seconds...
It's stange!
I have already rebuilded the index...but it didn't worked.
Thanks to everybody.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
