| using between slows query [message #501985] |
Sat, 02 April 2011 00:46  |
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
|
Senior Member |
|
|
My table has several date fields and my search screen has start and end date selection for all dates columns
so the query I create uses
audit_batch_received_date between :? and :?
where audit_batch_received_date is a date column.
I noticed add many between is slowing my query very much , even though I have indexes its still slow , is there any better way to use between in queries , is there any tuning can be performed when using between ?
CM: disabled smilies
[Updated on: Sat, 02 April 2011 05:02] by Moderator Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
