SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Select query

  1. #1
    SitePoint Zealot contactnaveen's Avatar
    Join Date
    Oct 2004
    Location
    India
    Posts
    169
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Select query

    1. select * from tb;

    or

    2. select c1,c2,c3 from tb; (I specified all the column names under the table tb)

    which will be faster 1 or 2????

  2. #2
    Tranceoholic lilleman's Avatar
    Join Date
    Feb 2004
    Location
    Írebro, Sweden
    Posts
    2,716
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    I asked the same question a couple of months ago. You'll find my thread here.
    ERIK RIKLUND :: Yes, I've been gone quite a while.


Bookmarks

Posting Permissions

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