> This select though is very expensive, per our DBA's. Could it be because > there are over 4 million rows?
Yes. Don't believe there's an index on TICKETGRANTINGTICKET_ID. Any query on an un-indexed column on a table that size would be expensive. 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
