I have a huge existing Order Management Application.

Now, in the main ORDER Table, i am adding a new column: IS\_HISTORICAL. If its value is: TRUE, means the Order is Historical now, and should not show up in application.

Now, i have to modify many SQL Queries in my existing application so that they select only those orders whose IS\_HISTORICAL is 'FALSE' - i.e add following in WHERE clause:

```
  AND IS_HISTORICAL='FALSE'

```

**Question:** \*Is there a easier way - so that i do not have to modify so many application queries (to hide away historical orders)?  

Essentially all ORDERS marked as IS\_HISTORICAL='TRUE' should become invisible/un-available for read/updates!!\*

***Note:*** Right now the table sizes are not very huge, but ultimately i intend to partition the table by IS\_HISTORICAL true/false.