(Vivek Sharma) Conditions are mostly applied to a SQL Query to filter set of rows from a rowset. These conditions allow optimizer to make a sensible guess on the Indexes to be used and the execution path to be chosen. But apart from the Queries, these conditions can also be applied to Indexes to opt
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help