Index and table scan

  • Hi!

    Quick question : Do index scans needs to be avoided all the time? I know table scans are not good... but I'm not sure for index scans.

    Thanks,

    Erik

  • You WANT index scan : ) or index seek


    Kindest Regards,

    Vasc

  • Ok... I thought that index seek was faster than index scan. Guess I still have to read about that subject!

  • it is faster an index seek than an index scan


    Kindest Regards,

    Vasc

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

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