This select though is very expensive, per our DBA's. Could it be because there are over 4 million rows?
-----Original Message----- From: Marvin Addison [mailto:[email protected]] Sent: Thursday, April 17, 2014 11:38 AM To: [email protected] Subject: Re: [cas-user] TGT table not getting cleaned up > But the select below would never return anything since that > TICKETGRANTINGTICKET_ID would be null for us since we are not using any proxy. Don't believe that's true. The ? parameter placeholder can take a null value which would be treated by many query engines like an "IS NULL" where clause. Maybe your platform doesn't do that, but you shouldn't assume a zero result set based on the query string alone. M -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
