Re: [GENERAL] Indexes again

2006-02-02 Thread Silas Justiniano
I know understand. Thank you ;) On 2/2/06, Richard Huxton wrote: > Silas Justiniano wrote: > > Sorry, I'll remake (rewrite? redo? ... bad English :/ ) my question: > > > > I have Books, Authors and Intermediate table. At intermediate I'm > > currently using the following indexes: > > > > CR

Re: [GENERAL] Indexes again

2006-02-02 Thread Richard Huxton
Silas Justiniano wrote: Sorry, I'll remake (rewrite? redo? ... bad English :/ ) my question: I have Books, Authors and Intermediate table. At intermediate I'm currently using the following indexes: CREATE INDEX authorIndex ON Intermediate(author_id); CREATE INDEX bookIndex ON Intermedia

[GENERAL] Indexes again

2006-02-02 Thread Silas Justiniano
Sorry, I'll remake (rewrite? redo? ... bad English :/ ) my question: I have Books, Authors and Intermediate table. At intermediate I'm currently using the following indexes: CREATE INDEX authorIndex ON Intermediate(author_id); CREATE INDEX bookIndex ON Intermediate(book_id); I need a t