Index for username/password

Does this make sense for a logon table:

CREATE TABLE Logon
(
ID INT NOT NULL IDENTITY PRIMARY KEY,
name VARCHAR(15) NOT NULL,
password VARCHAR(15) NOT NULL
)
GO
CREATE UNIQUE INDEX IX_Logon_Name ON Logon(name)
CREATE INDEX IX_Logon_NameAndPassword ON Logon(name,password)
GO

I do want the name to be unique but also will search frequently on both
name & password. Is this how it should be done? I don't fully
understand the difference between placing a single index in name &
password VS one on both name & password.

.

Relevant Pages

  • DC to user ratio
    ... noticing it taking a few minutes for policies to apply when they boot up ... their computer and after logon. ... Prev by Date: ...
    (microsoft.public.win2000.active_directory)
  • RE: Domain controller cannot browse network
    ... I also cannot browse the exchange server - I get logon ... failure error messages. ... Prev by Date: ...
    (microsoft.public.windows.server.networking)
  • Login 2000 Problems
    ... to Logon: ... "The system cannot log you on now because the domain G27WG is not available" ... Any ideas how I can fix this? ... Prev by Date: ...
    (microsoft.public.win2000.general)
  • Ebbene sė...
    ... logon... ... Saluti, ... Zire ... Prev by Date: ...
    (it.comp.macintosh)
  • Limitlogon
    ... Is there feature to limit user from logon to multiple machines (Limitlogon)? ... Prev by Date: ...
    (microsoft.public.windows.server.active_directory)