TwoStep-AS Cluster Model Nugget Settings

Generate SQL for this model When using data from a database, SQL code can be pushed back to the database for execution, providing superior performance for many operations.

Select one of the following options to specify how SQL generation is performed.

• Default: Score using Server Scoring Adapter (if installed) otherwise in process If connected to a database with a scoring adapter installed, generates SQL using the scoring adapter and associated user defined functions (UDF) and scores your model within the database. When no scoring adapter is available, this option fetches your data back from the database and scores it in SPSS® Modeler.
• Score by converting to native SQL If selected, generates native SQL to score the model within the database.
  Note: Although this option can provide quicker results, the size and complexity of the native SQL increases as the complexity of the model increases.
• Score outside of the database If selected, this option fetches your data back from the database and scores it in SPSS Modeler.