KineticaAdo.QueryHints Class Reference

Query optimization hints extracted from SQL. More...

Public Member Functions
IDictionary< string, string >	ToInsertOptions ()
	Converts hints to insert options dictionary. More...
IDictionary< string, string >	ToQueryOptions ()
	Converts hints to query options dictionary. More...

Properties
int?	BatchSize [get, set]
	Batch size hint for bulk operations (KI_HINT_BATCH_SIZE). More...
bool	TruncateStrings [get, set]
	Whether to truncate strings that exceed column length (KI_HINT_TRUNCATE_STRINGS). More...
bool	UpdateOnExistingPk [get, set]
	Whether to update on existing primary key (KI_HINT_UPDATE_ON_EXISTING_PK). More...
bool	IgnoreExistingPk [get, set]
	Whether to ignore existing primary key (KI_HINT_IGNORE_EXISTING_PK). More...
bool	DisableMultihead [get, set]
	Whether to disable multi-head insert (KI_HINT_DISABLE_MULTIHEAD). More...
bool	UseKeyLookup [get, set]
	Whether to use key lookup optimization (KI_HINT_KEY_LOOKUP). More...
bool	ReplicationSync [get, set]
	Whether to use synchronous replication (KI_HINT_REPL_SYNC). More...
bool	ServerSideInsert [get, set]
	Whether to force server-side insert execution (KI_HINT_SERVER_SIDE_INSERT). More...
string?	PkConflictPredicateLowerColumn [get, set]
	Column name for lower predicate PK conflict resolution (KI_HINT_PK_CONFLICT_PREDICATE_LOWER). More...
string?	PkConflictPredicateHigherColumn [get, set]
	Column name for higher predicate PK conflict resolution (KI_HINT_PK_CONFLICT_PREDICATE_HIGHER). More...

Detailed Description

Query optimization hints extracted from SQL.

Supports JDBC-compatible KI_HINT_* syntax.

Definition at line 3209 of file KineticaAdo.cs.

Member Function Documentation

ToInsertOptions()

IDictionary<string, string> KineticaAdo.QueryHints.ToInsertOptions ( )

inline

Converts hints to insert options dictionary.

Definition at line 3266 of file KineticaAdo.cs.

ToQueryOptions()

IDictionary<string, string> KineticaAdo.QueryHints.ToQueryOptions ( )

inline

Converts hints to query options dictionary.

Definition at line 3289 of file KineticaAdo.cs.

Property Documentation

BatchSize

int? KineticaAdo.QueryHints.BatchSize

getset

Batch size hint for bulk operations (KI_HINT_BATCH_SIZE).

Definition at line 3214 of file KineticaAdo.cs.

DisableMultihead

bool KineticaAdo.QueryHints.DisableMultihead

getset

Whether to disable multi-head insert (KI_HINT_DISABLE_MULTIHEAD).

Definition at line 3234 of file KineticaAdo.cs.

IgnoreExistingPk

bool KineticaAdo.QueryHints.IgnoreExistingPk

getset

Whether to ignore existing primary key (KI_HINT_IGNORE_EXISTING_PK).

Definition at line 3229 of file KineticaAdo.cs.

PkConflictPredicateHigherColumn

string? KineticaAdo.QueryHints.PkConflictPredicateHigherColumn

getset

Column name for higher predicate PK conflict resolution (KI_HINT_PK_CONFLICT_PREDICATE_HIGHER).

When a PK conflict occurs, the row with the higher value in this column wins.

Definition at line 3261 of file KineticaAdo.cs.

PkConflictPredicateLowerColumn

string? KineticaAdo.QueryHints.PkConflictPredicateLowerColumn

getset

Column name for lower predicate PK conflict resolution (KI_HINT_PK_CONFLICT_PREDICATE_LOWER).

When a PK conflict occurs, the row with the lower value in this column wins.

Definition at line 3255 of file KineticaAdo.cs.

ReplicationSync

bool KineticaAdo.QueryHints.ReplicationSync

getset

Whether to use synchronous replication (KI_HINT_REPL_SYNC).

Definition at line 3244 of file KineticaAdo.cs.

ServerSideInsert

bool KineticaAdo.QueryHints.ServerSideInsert

getset

Whether to force server-side insert execution (KI_HINT_SERVER_SIDE_INSERT).

Definition at line 3249 of file KineticaAdo.cs.

TruncateStrings

bool KineticaAdo.QueryHints.TruncateStrings

getset

Whether to truncate strings that exceed column length (KI_HINT_TRUNCATE_STRINGS).

Definition at line 3219 of file KineticaAdo.cs.

UpdateOnExistingPk

bool KineticaAdo.QueryHints.UpdateOnExistingPk

getset

Whether to update on existing primary key (KI_HINT_UPDATE_ON_EXISTING_PK).

Definition at line 3224 of file KineticaAdo.cs.

UseKeyLookup

bool KineticaAdo.QueryHints.UseKeyLookup

getset

Whether to use key lookup optimization (KI_HINT_KEY_LOOKUP).

Definition at line 3239 of file KineticaAdo.cs.

---

The documentation for this class was generated from the following file:

• AdoDotnetDriver/KineticaAdo.cs