Sender: adsi...@gmail.com Subject: composite query performance depends on component ordering Message-Id: <caadnm_f7xeznnmop-fwgey-f9utjepynxdch3fxhqk6ncag...@mail.gmail.com> Recipient: adam.nicho...@hl.co.uk
______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________
--- Begin Message ---Hi guys, I am consistently seeing a 20% improvement in query retrieval times if I use the composite comparator "Timestamp:ID" instead of "ID:Timestamp" where Timestamp=Long and ID=~100 character strings. I am retrieving all columns (~1 million) from a single row. Why is this happening? Cheers, Alex
--- End Message ---
