View Single Post
  #2 (permalink)  
Old September 29th, 2003, 09:01 AM
tastaturbeschmutzer tastaturbeschmutzer is offline
Registered User
 
Join Date: Sep 2003
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think there's no point to that. date/time fields are usually stored in 32 bits, so date and time cannot be separated. If you need the index for faster access, then putting the index on the complete field should work fine.

Otherwise I'm not sure whether you need an index at all.