You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by rishi007bansod <ri...@gmail.com> on 2016/12/29 07:22:24 UTC

Scan query vs Sql query

From performance point of view which type of query is better? When should we
use scan query and  when should we use sql query?



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Scan-query-vs-Sql-query-tp9793.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Scan query vs Sql query

Posted by Sergi Vladykin <se...@gmail.com>.

If you know that you are going to scan the whole cache anyways, then
probably SCAN queries will perform better. SQL allows you to index fields
or even groups of fields and do lookups much faster.

Sergi

2016-12-29 10:22 GMT+03:00 rishi007bansod <ri...@gmail.com>:

> From performance point of view which type of query is better? When should
> we
> use scan query and  when should we use sql query?
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Scan-query-vs-Sql-query-tp9793.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>