Home » RDBMS Server » Performance Tuning » using between slows query (oralce 10g)
using between slows query [message #501985] Sat, 02 April 2011 00:46 Go to next message
miroconnect@yahoo.com
Messages: 199
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

Re: using between slows query [message #501986 is a reply to message #501985] Sat, 02 April 2011 01:24 Go to previous message
Michel Cadot
Messages: 58934
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post required information for optimisation.

Regards
Michel
Previous Topic: Performance tuning of query with self join
Next Topic: derived column index
Goto Forum:
  


Current Time: Fri Aug 29 09:25:30 CDT 2014

Total time taken to generate the page: 0.13368 seconds