OraFAQ Forum: Text & interMedia » how improve query speed in a table that can't build a index

Home » Server Options » Text & interMedia » how improve query speed in a table that can't build a index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how improve query speed in a table that can't build a index [message #75939]

Mon, 22 April 2002 18:10

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	intermedia query
Next Topic:	Re: Querying on CLOB data type column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 27 21:57:33 CDT 2025