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
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

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: 62231
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post required information for optimisation.

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

Current Time: Sun Nov 29 15:17:21 CST 2015

Total time taken to generate the page: 0.04805 seconds