We have a regular index on PATN_WKU, created with this command:
CREATE INDEX PATN_WKU_I on PATN(PATN_WKU);
I've tried to run the first of those two queries before, but I was never patient enough to wait for the return
(I guess a query like that uses either a metamorph index or does a table scan, and there are about three million rows in the table.) I'm running the second query now (it's been running for about 10 minutes), but it has not returned yet.