AI-powered
podcast player
Listen to all your favourite podcasts with AI-powered features
Index Only Scans for Critical Queries
There's a couple of other things in terms of queries that you can do to favor index only scan. Just checking that you do need all columns that are being requested. So I would fight hard to have single index only scan in most critical queries. In this case, I know this is the best performance pause was kind of kind of give me. But then my question is what's the state or your of your buffer pool and the file cache? Is it good? Because you started to keep the same data multiple multiple times, like many times, the same records,. basically, you have denormalized the situation. And probably you need more memory to keep because you have more pages. It