Posted by joeNOSPAM@BEA.com on 02/15/06 18:52

If you don't already have a unique index on this table, making an
index of that sort would help. The smaller the index (eg: on an int
column) the better.

• Next in forum: Query Help with Update statement, thanks!
• Prev in forum: Record Counter
• Thread view: Re: very slow query (select count(*) from table)

[Reply to this message]