CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2

Thread: help me !

  1. November 9th, 1999, 09:03 AM #1
    Guest

    help me !

    I have a table ( In mydatabase ) of customer files ( About 5.000.000 records )
    I want to find name of customer
    my query :" select cus_name from customer where cus_name like '%var%' "

    but it's very slowly
    hepl me !

    ( My PC : PII, 450Mhz, 128M ram, 4G HDD )

    Reply With Quote Reply With Quote
  2. November 9th, 1999, 09:48 AM #2
    Chris Eastwood
    Chris Eastwood is offline Senior Member
    Join Date
    May 1999
    Location
    Oxford UK
    Posts
    1,459

    Re: help me !

    >:" select cus_name from customer where cus_name like '%var%' "

    Do you have an index on the 'cus_name' column in the customer table ?


    Chris Eastwood

    CodeGuru - the website for developers
    http://codeguru.developer.com/vb
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured