SELECT SINGLE Statement

The Select Single Statement is used to ensure that only one row is read from the Database. The Search is terminated as soon as the that row is found with the required criteria. Select Single will definetly produce better performance then SELECT … UP TO 1 ROWS … END SELECT when you have something is search for in the where clause.