Post reply

easy one, maybe????

  • October 24, 2005 at 7:11 am

    #90420

    what seems to be the problem neat index according to vb.net

    Dim strSQL As String = _

    "USE FuelMaster" & vbCrLf & _

    "ALTER TABLE fill" & vbCrLf & _

    "ADD INDEX FuelCOMPIndex ON fill(filldate, companyno )"

    tnx

  • October 24, 2005 at 7:16 am

    #599466

    CREATE NONCLUSTERED INDEX IX_FuelCOMP ON dbo.Fill (filldate, companyno)

  • October 24, 2005 at 7:27 am

    #599469

    CREATE NONCLUSTERED INDEX IX_FuelCOMP ON FuelMaster.dbo.Fill (filldate, companyno)

    will alleviate the need for the USE statement

    Far away is close at hand in the images of elsewhere.
    Anon.

  • October 24, 2005 at 7:30 am

    #599473

    OK this worked. tnx,

    but if the tables are already created and there is alrady data loaded in them, shouldn't i use a alter table or wil this do the job and index all present data???

  • October 24, 2005 at 7:35 am

    #599477

    It will populate the index using the data already present, if any.

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply