Hi guys, OrientDB SQL engine should be smart enough on this simple query to rewrite it with the optimized version, but if you start adding conditions, parenthesis, etc. it couldn't be that smart.
Best Regards, Luca Garulli Founder & CEO OrientDB <http://t.sidekickopen36.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XYg3MhRp0VdV39R8qSMPYW5vw6HK56dLWCf96gZDg02?t=http%3A%2F%2Forientdb.com%2F&si=6613501067132928&pi=8cdd2d92-4e7f-4dfd-bd8c-909da9f4230b> On 9 February 2016 at 15:06, scott molinari <[email protected]> wrote: > I'd say it is because the rids are physical locations, so it is easy for > ODB to just go directly to the records and get them with the FROM clause. > Whereas, the WHERE clause is a filter, which means there needs to be a > separation of the records from a complete list (scan) of all the records. > One would think the system would be smart enough to reduce the WHERE/IN > when using @rid to the simple SELECT/FROM form, but I am sure there are > technical reasons why this isn't directly possible. > > Scott > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
