Re: Index reverse tables : are they useful ?

2011-06-24 Thread Alex Karasulu
On Fri, Jun 24, 2011 at 11:07 AM, Emmanuel Lécharny wrote: > On 6/24/11 10:04 AM, Alex Karasulu wrote: >> >> On Fri, Jun 24, 2011 at 11:00 AM, Emmanuel Lécharny >>  wrote: >>> >>> On 6/24/11 9:51 AM, Alex Karasulu wrote: >> >> The reverse index has no duplicate keys. The only way to get a

Re: Index reverse tables : are they useful ?

2011-06-24 Thread Emmanuel Lécharny
On 6/24/11 10:04 AM, Alex Karasulu wrote: On Fri, Jun 24, 2011 at 11:00 AM, Emmanuel Lécharny wrote: On 6/24/11 9:51 AM, Alex Karasulu wrote: The reverse index has no duplicate keys. The only way to get a duplicate key in the reverse index is if the same entry (i.e. 37) contained the same val

Re: Index reverse tables : are they useful ?

2011-06-24 Thread Alex Karasulu
On Fri, Jun 24, 2011 at 11:04 AM, Alex Karasulu wrote: > On Fri, Jun 24, 2011 at 11:00 AM, Emmanuel Lécharny > wrote: >> On 6/24/11 9:51 AM, Alex Karasulu wrote: >>> > The reverse index has no duplicate keys. The only way to get a > duplicate key in the reverse index is if the same entry

Re: Index reverse tables : are they useful ?

2011-06-24 Thread Alex Karasulu
On Fri, Jun 24, 2011 at 11:00 AM, Emmanuel Lécharny wrote: > On 6/24/11 9:51 AM, Alex Karasulu wrote: >> The reverse index has no duplicate keys. The only way to get a duplicate key in the reverse index is if the same entry (i.e. 37) contained the same value ('foo') for the same (sn

Re: Index reverse tables : are they useful ?

2011-06-24 Thread Alex Karasulu
On Fri, Jun 24, 2011 at 10:58 AM, Emmanuel Lécharny wrote: > On 6/24/11 9:51 AM, Alex Karasulu wrote: >> >>> Note that it's true for the AND connector, but even for the OR connector, >>> we >>> don't have this kind of issue. >> >> Sorry don't understand connector? You probably mean the cursors? >

Re: Index reverse tables : are they useful ?

2011-06-24 Thread Emmanuel Lécharny
On 6/24/11 9:51 AM, Alex Karasulu wrote: The reverse index has no duplicate keys. The only way to get a duplicate key in the reverse index is if the same entry (i.e. 37) contained the same value ('foo') for the same (sn) attribute. And this we know is not possible. So the lookups against the re

Re: Index reverse tables : are they useful ?

2011-06-24 Thread Emmanuel Lécharny
On 6/24/11 9:51 AM, Alex Karasulu wrote: Note that it's true for the AND connector, but even for the OR connector, we don't have this kind of issue. Sorry don't understand connector? You probably mean the cursors? Sorry, from the mathematic semantic stand point, OR and AND are connectors (A

Re: Index reverse tables : are they useful ?

2011-06-24 Thread Alex Karasulu
On Fri, Jun 24, 2011 at 10:47 AM, Emmanuel Lécharny wrote: > On 6/24/11 9:40 AM, Alex Karasulu wrote: >> >> On Thu, Jun 23, 2011 at 7:20 PM, Emmanuel Lecharny >>  wrote: >>> >>> Hi guys, >>> >>> as I was reviewing the Table interface, and the Index hierarchy, I had a >>> bit >>> of time to try to

Re: Index reverse tables : are they useful ?

2011-06-24 Thread Emmanuel Lécharny
On 6/24/11 9:40 AM, Alex Karasulu wrote: On Thu, Jun 23, 2011 at 7:20 PM, Emmanuel Lecharny wrote: Hi guys, as I was reviewing the Table interface, and the Index hierarchy, I had a bit of time to try to understand this part of the server I was not comfortable with. And I saw that each index is

Re: Index reverse tables : are they useful ?

2011-06-24 Thread Alex Karasulu
On Thu, Jun 23, 2011 at 7:20 PM, Emmanuel Lecharny wrote: > Hi guys, > > as I was reviewing the Table interface, and the Index hierarchy, I had a bit > of time to try to understand this part of the server I was not comfortable > with. And I saw that each index is using two tables : a forward and a

Index reverse tables : are they useful ?

2011-06-23 Thread Emmanuel Lecharny
Hi guys, as I was reviewing the Table interface, and the Index hierarchy, I had a bit of time to try to understand this part of the server I was not comfortable with. And I saw that each index is using two tables : a forward and a reverse table. The forward table is obviously mandatory. It i