DEV Community

Multiple-Column Indexes and Hashing: The Ultimate Guide to Boosting Database Performance

Lord Neic on October 05, 2023

Greetings, tech aficionados! Today, we're diving deep into the realms of multiple-column indexes and hashing—critical yet often overlooked aspects ...
Collapse
 
fschtn profile image
Francesco Schettino

It looks very interesting (specially the “Generated always as” that I didn’t knew)!

But, when I have to do a SELECT, do I have to generate the hash externally? In other words, the application should be responsible for generating it, right?