Home » RDBMS Server » Performance Tuning » how to increase search in the database
how to increase search in the database [message #137951] Mon, 19 September 2005 01:14 Go to next message
genialsenthil
Messages: 26
Registered: June 2005
Location: Chennai
Junior Member
Hai
This Senthil a junior oracle dba working in small consultant in chennai(india) and i want to how to make a database search very fast. and my server is in another city and my both the clients are in the another city and when they started for search the database gets very slow
so please kindly help me solve this problem
and also give step by step process

regards
senthil

Report message to a moderator

Re: how to increase search in the database [message #137991 is a reply to message #137951] Mon, 19 September 2005 05:56 Go to previous messageGo to next message
IngRMP
Messages: 7
Registered: September 2005
Location: Spain
Junior Member
Hi,

I think so, that you could use INDEXES, and read this document.

"sticky: Performance Tuning Sticky"

Report message to a moderator

Re: how to increase search in the database [message #138028 is a reply to message #137951] Mon, 19 September 2005 08:09 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
If you're doing lots of text-searching, look into Oracle Text.

Report message to a moderator

Previous Topic: The time of 1 Query is more than 1 hour, HELP ¡¡¡
Next Topic: Error while installing Statspack
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 17:23:19 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.