All, Thanks guys my query execution time is 0.06 seconds down from almost 2 minutes. Apparently the indexing worked. I don't have any joins or subselects on this table.
Regards, Joebert _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
