bindings docs: ordered reads, prefix matches, and the statement cache in 26.10.1 (#23) - #24

Closes #23.

What changed (docs/guide/core/queries.md only)

• Parameters: the eviction by one-off texts is described as before 26.10.1; from 26.10.1 the caches protect repeated statements, pasted values still cost a parse, and arcadedb.sqlStatementCache / arcadedb.opencypher.statementCache are named for applications that cannot bind (Queries that embed their values are re-parsed on every call (Cypher ~10x, SQL ~5x) and push parameterized statements out of the LRU statement cache: parameterize literals before the cache lookup? ArcadeData/arcadedb#8286).
• Ordered reads over an optional property: an ascending ORDER BY p LIMIT k scans the type for nulls first unless p is NOTNULL, the WHERE clause excludes nulls on p (IS NOT NULL, =, <, >; not >= or <=, per the merged fix), or the index is created with NULL_STRATEGY INDEX, with both DDL forms shown (SQL ORDER BY on an indexed property, ascending, scans the whole type for nulls before reading the index: 290 ms against 1 ms descending at 1M rows, even with NOTNULL or WHERE x IS NOT NULL ArcadeData/arcadedb#8664).
• Prefix matches: LIKE 'abc%' and STARTS WITH read an ordered index, case-insensitive indexes excepted, and Cypher min/max read an index end when the index is on that property alone and holds no nulls (Index-answerable queries planned as full scans: SQL LIKE 'prefix%', Cypher STARTS WITH, and Cypher min()/max() (80-340 ms against 0.3-4 ms for the equivalent rewrite at 1M rows) ArcadeData/arcadedb#8666).

How it was verified

• Every behaviour stated was measured on the merged upstream commits with the issues' own repros, Temurin 25 and 21 (.notes/bench/repros/planner-probe, literal-params): bfb9bc845a for SQL ORDER BY on an indexed property, ascending, scans the whole type for nulls before reading the index: 290 ms against 1 ms descending at 1M rows, even with NOTNULL or WHERE x IS NOT NULL ArcadeData/arcadedb#8664 and Queries that embed their values are re-parsed on every call (Cypher ~10x, SQL ~5x) and push parameterized statements out of the LRU statement cache: parameterize literals before the cache lookup? ArcadeData/arcadedb#8286, aeb3a745f6 for Index-answerable queries planned as full scans: SQL LIKE 'prefix%', Cypher STARTS WITH, and Cypher min()/max() (80-340 ms against 0.3-4 ms for the equivalent rewrite at 1M rows) ArcadeData/arcadedb#8666. The >=/<= exclusion comes from the merged commit 5c370998f0 and Luca's closing comment.
• No example is affected: example 05 orders a subquery, and example 19 orders by a hash-indexed property, which cannot serve ordered reads.
• mkdocs build --strict is clean.

🤖 Generated with Claude Code

https://claude.ai/code/session_01WWcDr7TwvcfMsQkeYQVHZr