I have a complex JOIN query involving multiple tables. In the ORDER BY clause, I placed four columns from three different tables. I created indexes for these columns, but I'm still experiencing a decrease in performance. Upon examining the EXPLAIN output, I noticed that the indexes I created are being ignored, and a sequential scan is being performed instead. I suspect that the issue may be related to ordering by multiple columns from different tables. It would be appreciated if you could create a video addressing this topic.
Good idea for a video. Do you know where the expensive steps are? I mean, is it the retrieval of data from the tables or the order by or something else? Perhaps indexes on the columns being joined on could help improve performance - if you haven’t already done that!
Really appreciate your advice, thank you very much for the time you spend doing those videos. It help me so much optimizing some databases I have. Best regards from the Dominican Republic
Writing this before watching: The way ive done pagination is theough LIMIT and OFFSET - Limit is set to number of results returned to page, Offset is number of results * current page number
Hi Friend, I need help with Oracle database installation in Intel MacBook Pro. I'm trying with Docker. I'm already Microsoft SQL using Docker. I have difficulty changing Oracle 23c XE password and Database login details. I don't know where I can find these. Please help me
Hi, the login details for the docker image should be on the page that you downloaded the image from. I assume it's on the Oracle container registry. I haven't used this because I don't have an Intel MacBook (I have an M1 MacBook so the Docker images don't work for me).
![Как спроектировать MySQL инфраструктуру для высоких нагрузок и как с ней жить [Хекслет]](/img/n.gif)
Incredibly useful, thanks a lot.
Glad it was helpful!
I enjoyed this. Please make a video on cursor pagination (especially without an auto incrementing column)
Thanks! Great suggestion!
I have a complex JOIN query involving multiple tables. In the ORDER BY clause, I placed four columns from three different tables. I created indexes for these columns, but I'm still experiencing a decrease in performance. Upon examining the EXPLAIN output, I noticed that the indexes I created are being ignored, and a sequential scan is being performed instead. I suspect that the issue may be related to ordering by multiple columns from different tables. It would be appreciated if you could create a video addressing this topic.
Good idea for a video. Do you know where the expensive steps are? I mean, is it the retrieval of data from the tables or the order by or something else? Perhaps indexes on the columns being joined on could help improve performance - if you haven’t already done that!
Really appreciate your advice, thank you very much for the time you spend doing those videos. It help me so much optimizing some databases I have.
Best regards from the Dominican Republic
You're welcome! I'm glad you like the videos.
Wow! This is really tricky!
Thank you very much for the video!
You’re welcome!
Writing this before watching: The way ive done pagination is theough LIMIT and OFFSET - Limit is set to number of results returned to page, Offset is number of results * current page number
Yeah, that's the way I usually do it and what's mentioned in the video.
@@DatabaseStar always nice to see I'm on the right track! :)
Love your explanation style. Subscribed!
Thanks, glad you liked it!
Hi Friend,
I need help with Oracle database installation in Intel MacBook Pro.
I'm trying with Docker.
I'm already Microsoft SQL using Docker.
I have difficulty changing Oracle 23c XE password and Database login details.
I don't know where I can find these.
Please help me
Hi, the login details for the docker image should be on the page that you downloaded the image from. I assume it's on the Oracle container registry. I haven't used this because I don't have an Intel MacBook (I have an M1 MacBook so the Docker images don't work for me).
Good👍
Thanks!
Super!
Thanks!
Which application is this?
This is pgAdmin, an SQL editor for Postgres.
it's not dah-tah...
it's daaay-tah!
Haha yeah I hear that sometimes (pronunciation of the word data)