Changes between Version 3 and Version 4 of OtherTopics


Ignore:
Timestamp:
07/08/26 21:21:23 (4 days ago)
Author:
231118
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • OtherTopics

    v3 v4  
    2121* '''After Index Creation:'''
    2222  * Plan Output: `Index Scan` processing nodes filtering via the composite predicate.
    23   * Execution Time: 16.293 ms
    24 [[Image(ss1_after.png)]]
     23  * Execution Time: 3.271 ms
     24[[Image(ss1_after.2.png)]]
    2525
    2626* '''Index Usage Verification:''' Yes, the PostgreSQL engine bypassed raw relational sequential evaluation and bound query execution directly via index nodes inside the initial windowed CTE materialization.