General

Profile

Igor Skornyakov

Issues

Projects

Activity

02/25/2021

03:07 PM Database Feature #1587: implement full support for word indexes
Eric Faulhaber wrote:
> A separate thought: what if we remove the @distinct@ keyword? Unless I'm reading the plan wr...
02:45 PM Database Feature #1587: implement full support for word indexes
Eric Faulhaber wrote:
> Thank you.
>
> Are these two statements functionally equivalent?
>
> 1)
>
> [...]
...
02:06 PM Database Feature #1587: implement full support for word indexes
Eric Faulhaber wrote:
> What is the SQL for the expression @"s0 | s1"@?
>
> For @"(s0 | s1) & s5*"@?
>
> (LE: ...
01:53 PM Database Feature #1587: implement full support for word indexes
Eric Faulhaber wrote:
> Igor, can't the first form of the SQL be simplified as follows?
> In other words, why is th...
11:02 AM Database Feature #1587: implement full support for word indexes
Eric Faulhaber wrote:
> Yes, I was looking at the sort part of the plan, but you are right that the parts below do l...
10:54 AM Database Feature #1587: implement full support for word indexes
Eric Faulhaber wrote:
> Igor Skornyakov wrote:
>
> > At this moment I'm looking how to change SQL re-writing usin...
10:30 AM Database Feature #1587: implement full support for word indexes
I've added two things to the word tables support.
# The re-writing of the SQL queries with @CONTAINS@ re-writing can...
04:27 AM Database Feature #1587: implement full support for word indexes
With a logically equivalent but different re-written SQL statement using @WITH@ clause:...
03:46 AM Database Feature #1587: implement full support for word indexes
Adding index on the 'word' field in the word tables helps. The times are (see #1587-357)
|expr |records|e...
03:09 AM Database Feature #1587: implement full support for word indexes
Word tables' tests to @sftp://xfer.goldencode.com/opt/testcases/@ revision 1008.
Tests (including Java project for g...

Also available in: Atom