No,I am just asking for a solution to speed up my queries. Martijn Tonies wrote: > >> I will very often do query like this: >> >> select * from mytable where create_date >='...' and create_date <='....' >> >> can I create a index on the column create_date? >> > > Have you tried it? > > >> what is the best practise? >> > > Martijn Tonies > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & > MS SQL Server > Upscene Productions > http://www.upscene.com > My thoughts: > http://blog.upscene.com/martijn/ > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]