Home » SQL & PL/SQL » SQL & PL/SQL » How to tune the query with BETWEEN but no index
How to tune the query with BETWEEN but no index [message #233668] Fri, 27 April 2007 02:35 Go to next message
aditya449
Messages: 6
Registered: October 2006
Location: india
Junior Member
Hi,
I have got a query to tune in which there is BETWEEN clause but no index. So it is taking time in hrs. I canno create index column so what are the other options avaliable for me.
any suggestions would be appreciated.

Thanks
Aditya
Re: How to tune the query with BETWEEN but no index [message #233679 is a reply to message #233668] Fri, 27 April 2007 02:59 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Please reread your question.
Now assume you have NO idea what you are working on (sort of like we do) and reread it again.
Don't you think you should tell us a tad more context?
Like your query, table-constructs, data-distribution?
Previous Topic: list stored procedures
Next Topic: where are the procedures stored
Goto Forum:
  


Current Time: Wed Dec 07 14:21:32 CST 2016

Total time taken to generate the page: 0.07495 seconds