User bio
404 bio not found
Member since Oct 24, 2022
Posts:
show all 34
Replies:
show all 74
Dmitrii Baranov · Feb 15 go to post

Thanks Theo, I've also realized that IRIS is much more capricious than Postgres and that I will have to spend half my life tuning indexes in it.

Dmitrii Baranov · Feb 15 go to post

Is your account hacked or what. This is the second or third month in a row that you've been asking strange questions (almost) every day.

* * *

Essentially, I would recommend always using Return to exit a function (as in all other programming languages) and Quit to exit a loop.

Dmitrii Baranov · Jan 21 go to post

Hi Vitaly and thanks for the idea. The table contains 3.5M rows

create table test as select row_status from <src>
create bitmap index test_row_status_idx on test(row_status)

select top 10 ID from test where row_status in ('U','I') order by ID

0.579s

So most probably you are right and the table indeed has some issues with indexes

Certifications & Credly badges:
Dmitrii has no Certifications & Credly badges yet.
Followers:
show all 1
Lucy M.
Following:
Dmitrii has not followed anybody yet.