3 million records [message #38242] |
Wed, 03 April 2002 20:34 |
jeo
Messages: 1 Registered: April 2002
|
Junior Member |
|
|
I am creating a search application that will be checking against a table that has 3 million records.
So speed is a very important factor here....
In a simple query such as select name from tablename where name ='Jeo'
What can I do to make this be lighting fast.
Using an index on the column - done
Not to use "like" - done
What else can I do.......
- Are Materialized views of any value?
- Using a stored procedure instead of inline sql
Any ideas?
|
|
|
|
Re: 3 million records [message #38262 is a reply to message #38242] |
Fri, 05 April 2002 03:23 |
jim
Messages: 74 Registered: July 2000
|
Member |
|
|
If your using a version of Oracle that allows for FUNCTION based indexes, then you can use functions as long as you can build a function based index on the columns that your going against. Now, I try and avoid it but it is there, I have used it and it works as good as any old other index (to a degree, that is).
|
|
|