Home » Server Options » Text & interMedia » how improve query speed in a table that can't build a index
how improve query speed in a table that can't build a index [message #75939] Mon, 22 April 2002 18:10 Go to next message
feiysu
Messages: 3
Registered: April 2002
Junior Member
i build a table,but the table can't build a index because something,how improve query speed in the table???
thanks your answer
Re: how improve query speed in a table that can't build a index [message #75941 is a reply to message #75939] Wed, 24 April 2002 09:58 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
why cant u build an index for a specific table..Explain your scenario in detail.

Without index..I think you can still analyse the table and collect statistics and force some hints in my query to improve performance
Previous Topic: intermedia query
Next Topic: Re: Querying on CLOB data type column
Goto Forum:
  


Current Time: Fri Dec 19 16:53:58 CST 2014

Total time taken to generate the page: 0.12052 seconds