Re: Need Help optimizing stored procedure
Hi,
Have you tried adding an index on tagTable (TagName)?
Also perhaps try floattable(DateAndTime) or maybe a combined index, however I think the first suggestion will be the better one.
Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com
Subject
Views
Written By
Posted
2604
November 21, 2005 11:21AM
Re: Need Help optimizing stored procedure
1264
November 22, 2005 12:47AM
1435
November 22, 2005 07:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.