Which is more efficient "Between phrase" or "greater, lesser equal phrase"

1 post / 0 new
Anonymous
Which is more efficient "Between phrase" or "greater, lesser equal phrase"

A DB2 query could be written in more than one ways, we can use a between phrase to fetch data in a range or we can use the greater, lesser, equal operators. Can someone let me know which one would be more efficient approach out of the two using between or using > < = operators

"; ; ; ;
Sponsored Listing