[
https://issues.apache.org/jira/browse/ROL-1687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13598254#comment-13598254
]
Glen Mazza commented on ROL-1687:
---------------------------------
Original Poster, Boris, had indicated the index wouldn't help, problem with the
query:
http://markmail.org/message/dgipcifrl67rqigq#query:+page:1+mid:2rkub54tasubfkem+state:results
> Indexes missing in createdb.sql
> -------------------------------
>
> Key: ROL-1687
> URL: https://issues.apache.org/jira/browse/ROL-1687
> Project: Roller
> Issue Type: Bug
> Components: Database Access & Data Model
> Affects Versions: 4.0
> Reporter: David Johnson
> Assignee: Roller Unassigned
>
> via Boris Milikič
> Did you created missing indexes in rollerdb (4.0):
> create index ws_bloggercatid_idx on website(bloggercatid);
> create index ws_defaultcatid_idx on website(defaultcatid );
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
