Odg: Question about Hash Indexes

2020-02-19 Thread Mario Ivanac
Thanks for clarification. Šalje: Jason Huynh Poslano: 19. veljače 2020. 18:05 Prima: geode Predmet: Re: Question about Hash Indexes Hi Mario, >From my understanding: 1.) The Hash Index was implemented unlike a traditional hash index, instead it is more o

Re: Question about Hash Indexes

2020-02-19 Thread Jason Huynh
Hi Mario, >From my understanding: 1.) The Hash Index was implemented unlike a traditional hash index, instead it is more of a memory saving index that uses hashing to not store keys. When the backing data structure needs to expand, it needs to rehash a lot of data and this can be detrimental at ru

Question about Hash Indexes

2020-02-19 Thread Mario Ivanac
Hi geode dev, could you help us with some questions regarding Hash Indexes: 1. Why are Hash Indexes deprecated? 2. Are there any plans in the future for there removal? Thanks, Mario