Re: speed of query/can index help?
Posted by:
Elli
Date: June 26, 2009 08:56PM
Try index on (day, msgNum).
CREATE INDEX index_day_msgNum ON syslogD (day, msgNum)
Measure the time before and after and see if there is a significant difference.
Edited 1 time(s). Last edit at 06/26/2009 08:56PM by Elli .
Subject
Views
Written By
Posted
4060
June 26, 2009 06:15PM
Re: speed of query/can index help?
1890
June 26, 2009 08:56PM
1898
June 26, 2009 09:39PM
1968
June 27, 2009 03:04AM
1857
June 27, 2009 06:59AM
1866
June 27, 2009 07:38AM
1913
June 27, 2009 07:45AM
1823
June 27, 2009 10:39AM
1856
June 29, 2009 07:13AM
1782
June 30, 2009 12:26AM
1859
June 30, 2009 08:08AM
1927
June 30, 2009 10:36PM
1807
July 01, 2009 01:33PM
1734
July 01, 2009 08:22PM
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.