|
Subject:
|
Datetime Field as index
|
|
Posted By:
|
daworm
|
Post Date:
|
7/26/2006 3:36:53 AM
|
Hi
Im wondering if a datetime field be indexed to improve my application's performance when comparing fetching rows based on date attributes. Like I want to fetch all rows that are older by a particular date and have them sorted by date.
Ron
http://www.pinoy-dream-academy.com
|
|
Reply By:
|
jmaronilla
|
Reply Date:
|
8/8/2006 11:26:52 PM
|
daworm,
Yes, I have done alot of times.
I even used this index to populate a default integer value
in a field and a username. This way I would know how many
times a user has transact a table/database.
Hope this helps.
cheers,
jmaronilla
|
|
Reply By:
|
yeheycebu
|
Reply Date:
|
9/17/2006 11:33:55 PM
|
I think the comment is correct..
http://www.pinoydreamacademy.info
|
