Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ignite.apache.org
Date: Wed, 22 Jun 2016 00:53:20 -0700 (PDT)
From: mrinalkamboj <mrinal.technology@gmail.com>
To: user@ignite.apache.org
Message-ID: <1466582000535-5783.post@n6.nabble.com>
Subject: Multiple column filtering and sorting in Apache Ignite
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
archived-at: Wed, 22 Jun 2016 08:09:37 -0000

Following is my Poco class, my query include a set of filters on few columns,
which is facilitated using the QuerySqlField attribute, further there's
multiple column sorting, for which the fields are indexed, now my
understanding is indexing has a role only in sorting, but in this case user
can ask for Ascending or Descending and the combination of columns like
"OrderId Asc,OrderName desc"

- What kind of index can facilitate this kind of query ?
- Can a field be indexed for both ascending and descending ?
- Are the group indexes required in this case  ?

In my view it might not be practical to create index for all the 

public class OrderEntity
{
        [QuerySqlField(IsIndexed = true)]
        public int OrderId { get; set; }

        [QuerySqlField(IsIndexed = true)]
        public string OrderName { get; set; }

        [QuerySqlField(IsIndexed = true)]
        public DateTime OrderDateTime { get; set; }

        [QuerySqlField(IsIndexed = true)]
        public double OrderValue { get; set; }

        [QuerySqlField(IsIndexed = true)]
        public string OrderAddress { get; set; }        
}


--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Multiple-column-filtering-and-sorting-in-Apache-Ignite-tp5783.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.