Home » RDBMS Server » Performance Tuning » Search option
Search option [message #199070] Fri, 20 October 2006 00:20 Go to next message
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
Re: Search option [message #199094 is a reply to message #199070] Fri, 20 October 2006 02:21 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Search option [message #199519 is a reply to message #199094] Wed, 25 October 2006 00:10 Go to previous messageGo to next message
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
Senior Member
Hi,


Thanx ,

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

Re: Search option [message #199523 is a reply to message #199519] Wed, 25 October 2006 00:29 Go to previous message
rleishman
Messages: 3724
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
Previous Topic: Performance Tuning from scratch!
Next Topic: Statspack: How to reduce the LNS wait for LGWR redo EVENT and CPU TIME
Goto Forum:
  


Current Time: Fri Dec 09 10:00:34 CST 2016

Total time taken to generate the page: 0.08150 seconds