+ Reply to Thread
Results 1 to 2 of 2

Thread: speeding up a query

  1. #1
    Henley12
    Henley12 is offline
    Barn Newbie Henley12 is an unknown quantity at this point Henley12's Avatar
    Join Date
    Oct 2009
    Posts
    19
    Rep Power
    3

    speeding up a query

    I have a huge table that I am trying to query for a date range. Is it faster to do a select on just the fields I need as opposed to a SELECT * FROM (tblname)?
    Henley12, October 21st, 2009 12:36 PM
    Reply With Quote Reply With Quote
  2. #2
    jmurrayhead
    jmurrayhead is offline
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Reston, VA
    Posts
    4,547
    Blog Entries
    9
    Real Name
    Jason
    Rep Power
    22

    Yes, it's always better to only bring back the columns that you are going to use. Also, look into creating indexes on your tables. Indexes provide for faster searching (as long as you don't over do it).
    jmurrayhead, October 21st, 2009 12:55 PM
    jmurrayhead
    If you agree, give me rep.
    If you like it here...throw us a few bones to help support us.

    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Similar Threads

  1. SQL Query in Excel csv using MS Query
    By richyrich in forum Microsoft Office
    Replies: 2
    Last Post: August 11th, 2009, 11:50 AM

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

Forum Rules


SEO by vBSEO