User Guide > Data Ship Performance Optimization > Disabling Data Ship for Specific Query SQL
 
Disabling Data Ship for Specific Query SQL
The data ship optimization is configured for each data source. A data source might have hundreds of queries that it runs. Some of those queries can benefit from having the data ship optimization enabled and so you must configure the data ship. However, there might be a few queries that do not benefit from using the data ship optimization. For those queries that do not benefit from the optimization, you must disable the optimization. For more information on data ship options, see the TDV Reference Guide.
To disable data ship for specific queries
1. Open Studio.
2. Open the view or procedure for which you want to disable data ship.
3. Select the SQL tab.
4. Add the following hint syntax to the SELECT statement:
{OPTION DATA_SHIP_MODE="DISABLED"}
 
5. Save the change.