CData Cmdlets for Amazon Redshift 2019 - Online Help
Questions / Feedback?

AllowPreparedStatement Parameter (Connect-Redshift Cmdlet)

CData Cmdlets for Amazon Redshift 2019 - Build 19.0.7354

Prepare a query statement before its execution.

Syntax

Connect-Redshift -AllowPreparedStatement bool

Remarks

If the AllowPreparedStatement property is set to false, statements are parsed each time they are executed. Setting this property to false can be useful if you are executing many different queries only once.

If you are executing the same query repeatedly, you will generally see better performance by leaving this property at the default, true. Preparing the query avoids recompiling the same query over and over. However, prepared statements also require the cmdlet to keep the connection active and open while the statement is prepared.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0