i have a large book database and i want to search based on the isbn no
but there is no primary key in my table how can i make a search fast

pl suppy with detail answer
thanks in adv

add an index to the table for the column isbn

Regards
Ganesh

Why not identify a primarykey on that table? How about using ISBN as primary key field? Is that duplicated in the table?

But still an index on ISBN Number column would make that fast.

Cheers!

_________________________
- Vijay G
Strive for Perfection

pl specify the cmd for creating the indexing when there is no primary key will it make the search fast or it will effect the other operation like insert/update etc

You could check for command in Bools online. Search for CREATE INDEX

Or the same can be achieved from Enterprise manager.

I don't think that would have a major hit on the performance when indexed on this, unless it contains duplicate ISBNs.

But explain why is that you don't want to create a primary key?

Cheers!

_________________________
- Vijay G
Strive for Perfection

we don't have duplicate ISBN's but still it takes lot of time for
select isbn from books -->
now suppose i create an isbn as primary key will it effect the speed
we have 20lac of data
if yes then again the indexing is reqd pl specify with command

Since you dont have duplicate ISBN's, why dont you create a primary key on that column and also a Clustered index on the same. That will make searching a lot more fastor. Setting the appropriate fill factor will also help in improving the performance

Regards
Ganesh

thnks
it works
i have created isbn as a primary key now i want to search on basis of title or any other field say publishername
which indexing should i use for title/publishername and how to write the sql statement for it
thanks

It is adviced to have an index in each of the columns involved in the "Where" clause.

Regards
Ganesh

how to create index on more than one col
Is that indexing will only non clust
please write the statement for it
thanks