Apache.Ignite.Core.Cache.Query.SqlFieldsQuery Class Reference

SQL fields query. More...

Public Member Functions
	SqlFieldsQuery (string sql, params object[] args)
	Constructor. More...
	SqlFieldsQuery (string sql, bool loc, params object[] args)
	Constructor, More...
override string	ToString ()
	Returns a string that represents this instance. More...

Public Attributes
const int	DfltPageSize = 1024
	Default page size. More...

Properties
string	Sql [get, set]
	SQL. More...
object[]	Arguments [get, set]
	Arguments. More...
bool	Local [get, set]
	Local flag. When set query will be executed only on local node, so only local entries will be returned as query result. More...
int	PageSize [get, set]
	Optional page size. More...
bool	EnableDistributedJoins [get, set]
	Gets or sets a value indicating whether distributed joins should be enabled for this query. More...
bool	EnforceJoinOrder [get, set]
	Gets or sets a value indicating whether join order of tables should be enforced. More...

Detailed Description

Constructor & Destructor Documentation

Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.SqlFieldsQuery	(	string	sql,
		params object[]	args
	)

Parameters

sql	SQL.
args	Arguments.

Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.SqlFieldsQuery	(	string	sql,
		bool	loc,
		params object[]	args
	)

Parameters

sql	SQL.
loc	Whether query should be executed locally.
args	Arguments.

Member Function Documentation

override string Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.ToString

(

)

Returns

A string that represents this instance.

Member Data Documentation

const int Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.DfltPageSize = 1024

Property Documentation

object [] Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Arguments

getset

bool Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.EnableDistributedJoins

getset

When disabled, join results will only contain colocated data (joins work locally). When enabled, joins work as expected, no matter how the data is distributed.

true if enable distributed joins should be enabled; otherwise, false.

bool Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.EnforceJoinOrder

getset

When true, query optimizer will not reorder tables in join.

It is not recommended to enable this property until you are sure that your indexes and the query itself are correct and tuned as much as possible but query optimizer still produces wrong join order.

true if join order should be enforced; otherwise, false.

bool Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Local

getset

Defaults to false.

int Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.PageSize

getset

Defaults to DfltPageSize.

string Apache.Ignite.Core.Cache.Query.SqlFieldsQuery.Sql

getset