Re: Multiple indexes on same column

Andrea Gangini <[EMAIL PROTECTED]> wrote on 22/07/2005 10:17:34: > I have a column in one of my table, which: > - must be unique > - must be indexed because almost all queries are "SELECT .. WHERE > COLUMN LIKE " > > I created two indexes this column, one of type UNIQUE and a normal one

Multiple indexes on same column

I have a column in one of my table, which: - must be unique - must be indexed because almost all queries are "SELECT .. WHERE COLUMN LIKE " I created two indexes this column, one of type UNIQUE and a normal one, because I thought that the unique index and a normal indexes were differ

Re: can you drop multiple indexes at one time?

Donny Simonton wrote: I definitely don't see this in the documentation anywhere, but can you drop multiple indexes at one time with an alter table? Donny From the manual <http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html>, ALTER TABLE has syntax ALTER [IGNORE] TAB

can you drop multiple indexes at one time?

I definitely don't see this in the documentation anywhere, but can you drop multiple indexes at one time with an alter table? Donny

Accessing multiple indexes

What if you have a query with a result set of just 10 rows but there are no indexed columns that can limit the result set to < 1 million rows? I really need to be able to use multiple indexes in a single table query and I don't want to have to perform self joins or create temp tables. Is the

Re: Accessing multiple indexes

ry can only use one index, right? O> Single index access is a problem when you very large tables. What if you O> have a query with a result set of just 10 rows but there are no indexed O> columns that can limit the result set to < 1 million rows? I really need to O> be able to use

Re: Multiple indexes

Hi. On Sat, May 11, 2002 at 11:40:03PM -0300, [EMAIL PROTECTED] wrote: > Hi, > > A field can belongs to 2 or more indexes? Yes. Why didn't you simply try? Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting,

Multiple indexes

Hi, A field can belongs to 2 or more indexes? Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br [EMAIL PROTECTED] Fone: (19) 3256-3577 sql, query --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.361 / Virus Databa

RE: multiple indexes

> Just a couple of questions regarding indexes... > > Can I have multiple indexes on the same column? Yes, but it's kind of pointless. > Will this decrease performance when inserting? Yes. > Can you create and remove indexes after the creatio

multiple indexes

Just a couple of questions regarding indexes... Can I have multiple indexes on the same column? Will this decrease performance when inserting? Can you create and remove indexes after the creation of the table? Thanks... :) --- Daniel Åkerud, [EMAIL PROTECTED