Index - which 1 to choose ?

good day, everyone

if i have a transaction table with fields below :

transaction_no, product_id, product_desc, product_qty, product_txn, transaction_date

can some expert here point out to me , which is the best cluster-index and non-clsuter index ?

and possible kindly please explain why is it so? i'm not good in database so just explain like to beginner

thank you very much for guidanceRead this:

http://www.sql-server-performance.com/mr_indexing.asp

Then come back if you have more questions.|||Hi nakata

Welcome to the forum :D

What are you going to do with the table? Index choice depends on this. Given its name I guess a lot of inserts. Many updates? Much querying? Any foreign keys? Any other fields you are likely to link with in any queries?

Are any of the fields likely to always increase in value for each successive record added? (e.g. the transaction_no and transaction_date look like good candidates)|||Damn these slow, clumsy fingers of mine :o And I forgot the phrase "monotonically increasing" :o :o