| Subject | RE: RE: oldest active transaction not available |
|---|---|
| Author | |
| Post date | 2013-10-14T09:19:47Z |
> the indices are used, but only the server knows why he scans the whole table.>> SQL:
> DELETE FROM
> DETAIL
> WHERE
> ID=? /* ID */
>
> Execution Plan:
> PLAN (DETAIL INDEX (I_DETAILS_ID))
>
> Statement Statistics:
| > Reads: 1,0 GB | Inserts: 25 | Indexed Reads: 25 |
| > Writes: 180,0 KB | Updates: 0 | Sequential Reads: 8.259.025 |
| > | Deletes: 25 | Table Scan: 100% |
>
1. Do you have complete execution stats, including fetches, backout\purge\expunge and so on ?
2. Do you run SS or CS ? If SS, you should know that tools such as isql\IBE reports stats for the whole database activity, not isolated by the single statement.
3. Do you have triggers for DELETE on this table ?
Regards,
Vlad