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!
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
can you give me query to demonstrate the problem of missing or duplicating data when it matches the same criteria. i have already tried but have never faced your issue
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).
I enjoyed this. Please make a video on cursor pagination (especially without an auto incrementing column)
Thanks! Great suggestion!
Wow! This is really tricky!
Thank you very much for the video!
You’re welcome!
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.
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!
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! :)
can you give me query to demonstrate the problem of missing or duplicating data when it matches the same criteria. i have already tried but have never faced your issue
Hi, I have a video on my channel about duplicate rows: ruclips.net/video/w9dwX7xsBgY/видео.html
@@DatabaseStar thank you
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)