Re: Searching on indexed char field...

[Paul DuBois]

At 13:39 -0500 3/10/03, Jason West wrote:
>Does anyone know of a way to speed up seek time when selecting based on
>an indexed char field? I have a query that I'm executing ('select * from
>Table where UserName = myname') and it takes approximately 7 seconds to
>execute this 1000 times (UserName is char[50], and it is indexed). If I
>change the query to search on UserID, an indexed integer field, the same
>test runs in less than 1 second...

If you're indexing all 50 characters, index fewer of them.

>
>Any help is appreciated...
>--
>Jason H. West
>Software Engineer
>
>Softek Software International, Inc.
>813 Pavilion Ct.
>McDonough, GA 30253
>678-583-5718
>jwest@stripped