-
Sybase Slow Update Query
This is a simple update query, but it takes 4 seconds to execute. The statement is:
UPDATE <TABLENAME> SET <FIELD1> = <FIELD1> + <SOMEVALUE1> WHERE <FIELD2> = <SOMEVALUE2>
Other tables in my database executes much faster.
The "problem table" has 100 columns and has 5000 records.
Can anyone help me in this one...
-
Sybase Slow Update Query (reply)
I already found a solution.
I added an index for <FIELD2>, and query runs faster.
Thanks anyway.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|