Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2008
    Posts
    4

    Unanswered: Do queries take up disk space?

    Hi! I'm new to using databases let alone Access DB. I'm not sure if this has been asked before, but I would like to know if creating queries take up disk space.
    Thanks.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, they do -- not for the data, but for the sql
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    creationg a query will take space.... but its so little as to be near negligable, compared to the size required for form & report design, or even data.

    Normal Queries are a text represntation of a question you ask the db. they don't actually store the data just the commands to re-create the data, that is refreshed when you run the query. However "make" queries do save a copy of the data.. thats why they are called "make" queres (select <blah> from <mytable> into <mynewtable>)

  4. #4
    Join Date
    Apr 2008
    Posts
    4
    Thanks for the helpful info!

Posting Permissions

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