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
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
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!
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).
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! :)
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!
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!
Incredibly useful, thanks a lot.
Glad it was helpful!
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).
Which application is this?
This is pgAdmin, an SQL editor for Postgres.
Good👍
Thanks!
Super!
Thanks!
it's not dah-tah...
it's daaay-tah!
Haha yeah I hear that sometimes (pronunciation of the word data)