new sql server application without indices?

Recently, I assumed responsibility for a SQL Server 6.5 application( I am an Oracle DBA).

This application is being purchased from a vendor. It is replacing an Oracle application.
I did not make the decision for accepting this vendor's application

Yesterday, I had to call the vendor as I had a question. It turns out that the application
--with about 70 tables -- will not have any indices, only primary keys that will be utilized
through Powerbuilder. There will be no foreign keys as all such constraints are
handled through PB code.

I have dealt with many different applications over the years and under different platforms
but I have never encountered an application where there are no indices. I have seen
application with way too many and even some with too few. Never an application
without any.

Has any one ever worked with, or dealt with, an application with no indicies? Is it
practical to attempt to use native PB code to replace indicies? If yes, was the application
running efficiently? Was everything through table scans? Any advise on how to deal with this vendor?

Right now there are no procedures or function -- just native sql code on the theory everything is faster
and more efficient? May be?

Thanks for any information.

David Spaisman

[Pratheep Premananth]

Hi

I am an MCP on SQL Server using SQL server + VB for the past 3 yrs. Its working fine and efficient..

You can create SQL Sever index with create index...stmt.
You can create an many indexes as you want...
The SQL Server optimizer decides which index to use by default or
use can force the optimizer to use a particular index..
Pls read an article on optimizing SQL Server (Technet/MSDN)

Regards

Pratheep
(antares@sri.lanka.net)







On 11/22/98 4:26:51 PM, wrote:
> Recently, I assumed responsibility for a SQL Server 6.5 application( I am
> an Oracle DBA).

This application is being purchased from a vendor. It is
> replacing an Oracle application.
I did not make the decision for
> accepting this vendor's application

Yesterday, I had to call the
> vendor as I had a question. It turns out that the application
--with
> about 70 tables -- will not have any indices, only primary keys that will
> be utilized
through Powerbuilder. There will be no foreign keys as all
> such constraints are
handled through PB code.

I have dealt with many
> different applications over the years and under different platforms
but I
> have never encountered an application where there are no indices. I have
> seen
application with way too many and even some with too few. Never an
> application
without any.

Has any one ever worked with, or dealt with,
> an application with no indicies? Is it
practical to attempt to use native
> PB code to replace indicies? If yes, was the application
running
> efficiently? Was everything through table scans? Any advise on how to deal
> with this vendor?

Right now there are no procedures or function -- just
> native sql code on the theory everything is faster
and more efficient?
> May be?

Thanks for any information.

David Spaisman