How can I improve performance of RADPOOL allocation with Oracle?
Contributed by “Paul O’Shea” (paul@genieinternet.com). Our pool allocation query is: FindQuery select TIME_STAMP, YIADDR, SUBNETMASK, DNSSERVER from RADPOOL_VW where POOL=’%0′ and STATE=0 and rownum=1 order by TIME_STAMP asc However you can’t use the RADPOOL table directly for this, so what we have done is created a ‘view’ of the table (thus RADPOOL_VW above in the query).
