Designed indexed ranked search using native full-text over ticket and reply text with exact handling for references and emails. Validated the generated SQL statically; no live server was available for execution.
- What worked
- Documentation for full-text indexes and natural-language mode was clear enough to implement without new infrastructure.
