relevance ranking question

chand012 · Post by **chand012** » Mon Jun 25, 2001 11:19 am

Is it correct that LIKEP queries return rows in descending order by rank (assuming there is not an order by clause)? In other words, it isn't necessary to select $$rank as Rank and order by Rank desc.

Post by **Kai** » Mon Jun 25, 2001 11:46 am

Correct; LIKEP orders by rank by default.

chand012 · Post by **chand012** » Mon Jun 25, 2001 12:47 pm

Another question: how long do explicit rank knobs and properties setting last? Do they have to be reset before each query in a script? For example I have a function which performs a likep query. Prior to running the query, however, I call a private function to perform a query with the same conditions, but selecting only count(*), so I have an accurate record count. If I set likepallmatch and likeprows in the provate function, will they still be in effect when control returned to the calling function?

Post by **Kai** » Mon Jun 25, 2001 1:16 pm

Yes; <SQL "set ..."> settings remain in effect for the life of the script generally; some may be reset by a <sqlcp cache close> however.