Jump to content

craig1972

New Members
 View Profile  See their activity

  • Posts

    2

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

craig1972's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. craig1972
    Where did the notion of a subquery come in? I only want to know what to do with a column having both UNIQUE index and an INDEX index.
  2. craig1972
    Hi, It *is* something to worry about as it significantly reduces the speed of the query, as no index is used. What's the solution to this? Let's say I have a column COL1 in my db. This needs to be unique. But in conjunction with COL2, this also needs a separate index. How should I tell MySQL that it's OK to have the two indices and use both of them in queries? I am using MySQL 4.1.21-standard-l. Thanks!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.