Originally posted by samdba
Hi all,

1. Can I just go on creating indexes where table is being queried without using indexes?

Thanks in Adv.
Not a good idea....rather try optimising the query which fetches same result set...with join to indexed cols ( if u can, hopefully u cud use cols of PK's ).