OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Search option

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

Search option [message #199070]

Fri, 20 October 2006 00:20

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

Hi Friends,

Hi i am using search option in my query,

i.e

select * from tab_name where name like '%v_name%';

what type of index i have to create and what are the other methods to access the rows (or) retreive the rows fast.

thanx and regards
Selva

Report message to a moderator

Re: Search option [message #199094 is a reply to message #199070]

Fri, 20 October 2006 02:21

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If you can use it "WHERE name LIKE 'v_name%'", index created on 'name' column will be used if 'v_name' is (not sure about it!) 3-4 characters long (i.e. if you use first few letters of the 'name'). If I'm not wrong, use of '%v_name%' will not use index.

Report message to a moderator

Re: Search option [message #199519 is a reply to message #199094]

Wed, 25 October 2006 00:10

selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai

Senior Member

Hi,

Thanx ,

Any other method for this, reverse option , we can use ..............?

Report message to a moderator

Re: Search option [message #199523 is a reply to message #199519]

Wed, 25 October 2006 00:29

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

If you want full-text search capability, read the Text Reference and Text Application Developer's Guide manual.

Ross Leishman

Report message to a moderator

Previous Topic:	Performance Tuning from scratch!
Next Topic:	Statspack: How to reduce the LNS wait for LGWR redo EVENT and CPU TIME

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 29 13:20:55 CDT 2024