The index key (time desc, username, name, facility, event, sector, item,
details) could potentially be 32867 bytes long. However, an index key
must be less than 1/2 the page size, according to the "Page size and key
size" topic at
https://db.apache.org/derby/docs/10.15/ref/rrefsqlj20937.html Th
On 09/02/2021 19:50, Rick Hillegas wrote:
On 2/9/21 8:21 AM, John English wrote:
On 09/02/2021 18:05, Rick Hillegas wrote:
As Bryan points out, please consult the Tuning Guide for information
on how to view your query plan. In any event, your descending index
is not a covering index. That is,