|
If you were logged in you would be able to see more operations.
|
|
|
|
Original Estimate:
|
Unknown
|
Remaining Estimate:
|
Unknown
|
Time Spent:
|
Unknown
|
|
| Resolution Date: |
21/Nov/07
|
| Target: |
2.5.0
|
|
There are some queries (e.g. select count(*) from <tab>) that don't access any table fields (explicitly or implicitly). In this case, only the record header could be processed and the record data decompression could be avoided. Simple tests against the prototype implementation show about 50-80% of performance improvement (when appropriate data pages are cached).
|
|
Description
|
There are some queries (e.g. select count(*) from <tab>) that don't access any table fields (explicitly or implicitly). In this case, only the record header could be processed and the record data decompression could be avoided. Simple tests against the prototype implementation show about 50-80% of performance improvement (when appropriate data pages are cached). |
Show » |
| There are no comments yet on this issue.
|
|
Improvement
Resolved
Minor
Optimize data retrieval for tables when no fields are accessed