StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » SQL Views and Indexes

SQL Views and Indexes

Aaron Young — Tue, 08 Jul 2008 10:55:02 GMT

Hi,

I would like to add indexes to a couple of SQL Views in the DDT. However, when I edit the view in the DDT it doesn't detect all of the field names in the view. As a result, I can't add an index as it only allows an index to be added to a field that is detected in the view.

Is there a way around this?

Thanks,

Aaron

RE: SQL Views and Indexes

Aaron Young — Tue, 08 Jul 2008 10:55:02 GMT

You were right - I did really need it. Of course it means I have to do some work now :(

Thanks again - I really appreciate it!!!!!!

RE: SQL Views and Indexes

Trent L. Taylor — Tue, 08 Jul 2008 10:53:41 GMT

LOL...I knew that you were probably in the middle of it and it looked to be a quick fix. They can't all be that fast, but we try to accomodate when we can!

RE: SQL Views and Indexes

Aaron Young — Tue, 08 Jul 2008 10:49:47 GMT

Now come on - that is ridiculous. I post a problem at 4.26pm, you confirm it is a bug and have it fixed by 4.34pm? What were you doing keeping me waiting for those 8 minutes? Scandalous! :)

What can I say - excellent service again! :)

RE: SQL Views and Indexes

Trent L. Taylor — Tue, 08 Jul 2008 10:44:49 GMT

LOL...I undertstand....and I think that a performance bump is totally billable! :D

RE: SQL Views and Indexes

Aaron Young — Tue, 08 Jul 2008 10:43:03 GMT

I can imagine them in there but it appears some customers can't. :)

It appears a customer is trying to run a SQL query against one of our views with a WHERE clause and there is no index on the field. It was never intended for that purpose but the query is scanning through 20,000 records to return several hundred so a bump in performance will be welcome.

Wonder if I can charge for the performance bump :)

RE: SQL Views and Indexes

Trent L. Taylor — Tue, 08 Jul 2008 10:42:12 GMT

It is fixed. I have just attached the DDT and I ams also assuming that you are on the most recent 1.6.6 build (http://forum.strataframe.net/FindPost17560.aspx). If this is the case, you can just copy the attached EXE to the c:\program files\microfour\strataframe folder (I think that it where it should be :) ) and just replace the other EXE.

RE: SQL Views and Indexes

Trent L. Taylor — Tue, 08 Jul 2008 10:34:06 GMT

What, you can't just imagine those indexes in there? :D

It looks like a bug...I will get it fixed right now and post an update. Thanks!