3 Replies Latest reply on Jul 7, 2007 8:37 PM by 299178

    Use of functions

      The use of functions - a function with other selects (eg. calculate availability of a part) - is slowing down our system when we do a select over our product file.
      Is there some kind of rule when functions should be used or when we should try to create a more complex - combined - SQL that does not use the function.
      Can functions be used in the where clause without loosing a lot of speed?