ROWNUM affects performance?
Does any one know if using the ROWNUM in a SELECT statement will have an impact on execution times (i.e. less time or the same) or will simply just be "clipping" the result set? So for instance, lets say we have a complex query that has many joins and takes X amount of time to retrieve the first result set. If the same query is used but with a clause of ROWNUM = 1, will this have a impact on X?