As to the requirements of mass satellites TT&C data searching with time interval, and sorting the results by time, a storage and query method based on database time partition table and index organization table (IOT) is proposed. Time partition table can shorten the search time by storing data in the multiple physical table space. Furthermore, the response time can't increase with the growth of data volume. Index organization table can reduce the storage space occupancy by storing data directly in the index. However, the writing efficient is partially damaged. Through the testing and analyzing of a satellite, the validity and correctness of the method is proved. As a result, the efficiency of data storage and query is improved.